{"id":8508,"date":"2026-03-31T00:44:28","date_gmt":"2026-03-31T03:44:28","guid":{"rendered":"https:\/\/executestep.com\/?p=8508"},"modified":"2026-03-31T00:44:30","modified_gmt":"2026-03-31T03:44:30","slug":"resetar-sequences-oracle","status":"publish","type":"post","link":"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/","title":{"rendered":"Resetando Sequences no Oracle: RESTART e o M\u00e9todo Cl\u00e1ssico"},"content":{"rendered":"\n<p>Voc\u00ea precisa recriar um ambiente de testes, desfazer uma carga de dados ou simplesmente reiniciar a numera\u00e7\u00e3o de uma sequence. Qualquer que seja o motivo, resetar uma sequence no Oracle \u00e9 uma opera\u00e7\u00e3o comum \u2014 e que tem dois caminhos bem diferentes dependendo da vers\u00e3o do seu banco.<\/p>\n\n\n\n<p>Este post mostra os dois m\u00e9todos, explica o impacto do <strong>CACHE<\/strong>, como verificar depend\u00eancias antes de agir, e como resetar para um valor espec\u00edfico (n\u00e3o s\u00f3 para 1).<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Antes de Resetar: Verifique as Depend\u00eancias<\/h2>\n\n\n\n<p>Resetar uma sequence vinculada a uma chave prim\u00e1ria pode gerar conflitos de unicidade. Antes de qualquer coisa, verifique:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(2 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>-- Sequences usadas como DEFAULT em colunas\nSELECT\n    t.owner,\n    t.table_name,\n    t.column_name,\n    t.data_default\nFROM dba_tab_columns t\nWHERE UPPER(t.data_default) LIKE '%SEQ%'\n  AND t.owner = 'SEU_SCHEMA';\n\n-- Identity columns vinculadas a sequences internas\nSELECT\n    owner,\n    table_name,\n    column_name,\n    identity_column,\n    default_on_null\nFROM dba_tab_columns\nWHERE identity_column = 'YES'\n  AND owner = 'SEU_SCHEMA';<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #616E88\">-- Sequences usadas como DEFAULT em colunas<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    t.owner,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    t.table_name,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    t.column_name,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    t.data_default<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dba_tab_columns t<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">WHERE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">UPPER<\/span><span style=\"color: #D8DEE9FF\">(t.data_default) <\/span><span style=\"color: #81A1C1\">LIKE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">%SEQ%<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">AND<\/span><span style=\"color: #D8DEE9FF\"> t.owner <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">SEU_SCHEMA<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Identity columns vinculadas a sequences internas<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">owner<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    table_name,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    column_name,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    identity_column,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    default_on_null<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dba_tab_columns<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">WHERE<\/span><span style=\"color: #D8DEE9FF\"> identity_column <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">YES<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">AND<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">owner<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">SEU_SCHEMA<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Se a sequence alimenta uma coluna com dados existentes na tabela, resetar para 1 vai colidir com os registros j\u00e1 inseridos. Nesse caso, <strong>resetar para um valor maior que o MAX atual<\/strong> \u00e9 a sa\u00edda correta.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e9todo Moderno: ALTER SEQUENCE \u2026 RESTART (Oracle 18c\/19c+)<\/h2>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"has-small-font-size\">\u26a0\ufe0f <strong>Aten\u00e7\u00e3o:<\/strong> A cl\u00e1usula <code>RESTART<\/code> foi introduzida originalmente para uso interno da Oracle. Ela aparece na documenta\u00e7\u00e3o oficial do Oracle 19c, mas use com consci\u00eancia em produ\u00e7\u00e3o \u2014 teste no seu ambiente antes.<\/p>\n<\/blockquote>\n\n\n\n<p>A partir do Oracle 18c\/19c, voc\u00ea pode reiniciar uma sequence diretamente:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>-- Reinicia para o valor inicial (START WITH original)\nALTER SEQUENCE esquema.nome_sequence RESTART;\n\n-- Reinicia para um valor espec\u00edfico\nALTER SEQUENCE esquema.nome_sequence RESTART START WITH 1000;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #616E88\">-- Reinicia para o valor inicial (START WITH original)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> esquema.nome_sequence <\/span><span style=\"color: #81A1C1\">RESTART<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Reinicia para um valor espec\u00edfico<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> esquema.nome_sequence <\/span><span style=\"color: #81A1C1\">RESTART<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">START<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">WITH<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1000<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>O <code>RESTART<\/code> sem par\u00e2metro volta ao <code>START WITH<\/code> original da sequence. Se quiser um valor diferente, use <code>RESTART START WITH <valor><\/valor><\/code>.<\/p>\n\n\n\n<p>Para zerar o efeito do <strong>CACHE<\/strong> junto com o restart (evitar gaps por valores pr\u00e9-alocados perdidos):<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER SEQUENCE esquema.nome_sequence RESTART START WITH 1 NOCACHE;\n-- Depois, se quiser reativar o cache:\nALTER SEQUENCE esquema.nome_sequence CACHE 20;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> esquema.nome_sequence <\/span><span style=\"color: #81A1C1\">RESTART<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">START<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">WITH<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\"> NOCACHE;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Depois, se quiser reativar o cache:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> esquema.nome_sequence CACHE <\/span><span style=\"color: #B48EAD\">20<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e9todo Cl\u00e1ssico: INCREMENT BY Negativo (Oracle 12c e anteriores)<\/h2>\n\n\n\n<p>Este \u00e9 o m\u00e9todo que funciona em qualquer vers\u00e3o. Como o MINVALUE padr\u00e3o de uma sequence \u00e9 1, n\u00e3o \u00e9 poss\u00edvel simplesmente aplicar um INCREMENT BY negativo igual ao NEXTVAL atual \u2014 o Oracle rejeitaria com ORA-08004, pois o resultado passaria pelo 0. A solu\u00e7\u00e3o \u00e9 baixar o MINVALUE para 0 temporariamente.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(2 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>-- 1. Descubra o valor atual\nSELECT esquema.nome_sequence.NEXTVAL FROM dual;\n-- Resultado exemplo: 27\n\n-- 2. Baixe o MINVALUE para 0 e aplique o incremento negativo\nALTER SEQUENCE esquema.nome_sequence MINVALUE 0 INCREMENT BY -27 NOCACHE;\n\n-- 3. Consuma um NEXTVAL para efetivar o recuo\nSELECT esquema.nome_sequence.NEXTVAL FROM dual;\n-- Retorna: 0\n\n-- 4. Restaure o incremento (MINVALUE ainda est\u00e1 em 0 \u2014 n\u00e3o altere junto)\nALTER SEQUENCE esquema.nome_sequence INCREMENT BY 1;\n\n-- 5. Confirme: pr\u00f3ximo NEXTVAL \u00e9 1\nSELECT esquema.nome_sequence.NEXTVAL FROM dual;\n-- Retorna: 1\n\n-- 6. Agora restaure o MINVALUE\nALTER SEQUENCE esquema.nome_sequence MINVALUE 1;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #616E88\">-- 1. Descubra o valor atual<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> esquema.nome_sequence.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Resultado exemplo: 27<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- 2. Baixe o MINVALUE para 0 e aplique o incremento negativo<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> esquema.nome_sequence MINVALUE <\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\"> INCREMENT <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #B48EAD\">27<\/span><span style=\"color: #D8DEE9FF\"> NOCACHE;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- 3. Consuma um NEXTVAL para efetivar o recuo<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> esquema.nome_sequence.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Retorna: 0<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- 4. Restaure o incremento (MINVALUE ainda est\u00e1 em 0 \u2014 n\u00e3o altere junto)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> esquema.nome_sequence INCREMENT <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- 5. Confirme: pr\u00f3ximo NEXTVAL \u00e9 1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> esquema.nome_sequence.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Retorna: 1<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- 6. Agora restaure o MINVALUE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> esquema.nome_sequence MINVALUE <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"has-small-font-size\"><strong>Aten\u00e7\u00e3o ao CACHE:<\/strong> Se a sequence tem <code>CACHE<\/code> ativo, os valores pr\u00e9-alocados na SGA s\u00e3o perdidos em caso de restart do banco ou flush do cache \u2014 gerando gaps na numera\u00e7\u00e3o. Use <code>NOCACHE<\/code> durante o reset para ter previsibilidade no valor resultante e reative depois se necess\u00e1rio.<\/p>\n<\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"has-small-font-size\"><strong>Ordem importa:<\/strong> N\u00e3o tente restaurar <code>INCREMENT BY 1<\/code> e <code>MINVALUE 1<\/code> no mesmo comando enquanto o valor atual for 0 \u2014 o Oracle rejeita com ORA-04007. Restaure o INCREMENT BY primeiro, consuma o NEXTVAL (que entrega 1), e s\u00f3 ent\u00e3o ajuste o MINVALUE.<\/p>\n<\/blockquote>\n\n\n\n<p>Para resetar para um valor espec\u00edfico (ex: 5000), a f\u00f3rmula \u00e9 <code>valor_alvo - NEXTVAL_atual<\/code>:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>-- NEXTVAL atual: 27, alvo: 5000\n-- 5000 - 27 = 4973\nALTER SEQUENCE esquema.nome_sequence MINVALUE 0 INCREMENT BY 4973 NOCACHE;\nSELECT esquema.nome_sequence.NEXTVAL FROM dual;\nALTER SEQUENCE esquema.nome_sequence INCREMENT BY 1;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #616E88\">-- NEXTVAL atual: 27, alvo: 5000<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- 5000 - 27 = 4973<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> esquema.nome_sequence MINVALUE <\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\"> INCREMENT <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">4973<\/span><span style=\"color: #D8DEE9FF\"> NOCACHE;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> esquema.nome_sequence.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> esquema.nome_sequence INCREMENT <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Identity Columns: Caso Especial<\/h2>\n\n\n\n<p>Se a coluna usa <code>GENERATED AS IDENTITY<\/code> (introduzido no Oracle 12c), ela tem uma sequence interna gerenciada pelo pr\u00f3prio Oracle. O <code>ALTER SEQUENCE<\/code> direto n\u00e3o se aplica \u2014 use:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER TABLE esquema.tabela\n  MODIFY (coluna GENERATED AS IDENTITY (START WITH 1));<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> esquema.tabela<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">MODIFY<\/span><span style=\"color: #D8DEE9FF\"> (coluna <\/span><span style=\"color: #81A1C1\">GENERATED<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">AS<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">IDENTITY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #81A1C1\">START<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">WITH<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">));<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Ou para um valor espec\u00edfico:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER TABLE esquema.tabela\n  MODIFY (coluna GENERATED AS IDENTITY (START WITH 5000));<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> esquema.tabela<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">MODIFY<\/span><span style=\"color: #D8DEE9FF\"> (coluna <\/span><span style=\"color: #81A1C1\">GENERATED<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">AS<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">IDENTITY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #81A1C1\">START<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">WITH<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">5000<\/span><span style=\"color: #D8DEE9FF\">));<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Cen\u00e1rio Completo de Lab<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Setup<\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE TABLE lab_pedidos (\n    id     NUMBER PRIMARY KEY,\n    descr  VARCHAR2(100)\n);\n\nCREATE SEQUENCE lab_seq START WITH 1 INCREMENT BY 1 CACHE 20;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">lab_pedidos<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    id     <\/span><span style=\"color: #81A1C1\">NUMBER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">PRIMARY KEY<\/span><span style=\"color: #D8DEE9FF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    descr  <\/span><span style=\"color: #81A1C1\">VARCHAR2<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">lab_seq<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">START<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">WITH<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\"> INCREMENT <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\"> CACHE <\/span><span style=\"color: #B48EAD\">20<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Popula dados iniciais<\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>INSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido A');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido B');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido C');\nCOMMIT;\n\nSELECT lab_seq.NEXTVAL FROM dual;\n-- Retorna: 4<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido A<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido B<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido C<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">COMMIT<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> lab_seq.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Retorna: 4<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">M\u00e9todo Moderno \u2014 RESTART (19c+)<\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(2 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER SEQUENCE lab_seq RESTART START WITH 1 NOCACHE;\n\nSELECT lab_seq.NEXTVAL FROM dual;\n-- Retorna: 1\n\nSELECT lab_seq.NEXTVAL FROM dual;\n-- Retorna: 2\n\nSELECT lab_seq.NEXTVAL FROM dual;\n-- Retorna: 3<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> lab_seq <\/span><span style=\"color: #81A1C1\">RESTART<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">START<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">WITH<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\"> NOCACHE;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> lab_seq.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Retorna: 1<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> lab_seq.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Retorna: 2<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> lab_seq.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Retorna: 3<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>O RESTART entrega exatamente o valor definido no <code>START WITH<\/code>, sem surpresas.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">M\u00e9todo Cl\u00e1ssico \u2014 INCREMENT BY Negativo<\/h3>\n\n\n\n<p>Para demonstrar o m\u00e9todo cl\u00e1ssico, continue inserindo dados a partir do estado atual (NEXTVAL = 3 ap\u00f3s o teste acima) at\u00e9 acumular um volume maior:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(2 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>INSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido D');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido E');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido F');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido G');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido H');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido I');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido J');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido K');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido L');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido M');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido N');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido O');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido P');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido Q');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido R');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido S');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido T');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido U');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido V');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido W');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido X');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido Y');\nINSERT INTO lab_pedidos VALUES (lab_seq.NEXTVAL, 'Pedido Z');\nCOMMIT;\n\nSELECT lab_seq.NEXTVAL FROM dual;\n-- Retorna: 27<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido D<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido E<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido F<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido G<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido H<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido I<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido J<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido K<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido L<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido M<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido N<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido O<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido P<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido Q<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido R<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido S<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido T<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido U<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido V<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido W<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido X<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido Y<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">INSERT INTO<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos <\/span><span style=\"color: #81A1C1\">VALUES<\/span><span style=\"color: #D8DEE9FF\"> (lab_seq.NEXTVAL, <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">Pedido Z<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">COMMIT<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> lab_seq.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Retorna: 27<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Agora o reset:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(2 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>-- 1. Verifique o NEXTVAL atual\nSELECT lab_seq.NEXTVAL FROM dual;\n-- Retorna: 27\n\n-- 2. Baixe o MINVALUE para 0 e aplique o incremento negativo\nALTER SEQUENCE lab_seq MINVALUE 0 INCREMENT BY -27 NOCACHE;\n\n-- 3. Consuma um NEXTVAL para efetivar o recuo\nSELECT lab_seq.NEXTVAL FROM dual;\n-- Retorna: 0\n\n-- 4. Restaure o INCREMENT BY\nALTER SEQUENCE lab_seq INCREMENT BY 1;\n\n-- 5. Confirme o reset\nSELECT lab_seq.NEXTVAL FROM dual;\n-- Retorna: 1\n\n-- 6. Restaure o MINVALUE\nALTER SEQUENCE lab_seq MINVALUE 1;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #616E88\">-- 1. Verifique o NEXTVAL atual<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> lab_seq.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Retorna: 27<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- 2. Baixe o MINVALUE para 0 e aplique o incremento negativo<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> lab_seq MINVALUE <\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\"> INCREMENT <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #B48EAD\">27<\/span><span style=\"color: #D8DEE9FF\"> NOCACHE;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- 3. Consuma um NEXTVAL para efetivar o recuo<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> lab_seq.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Retorna: 0<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- 4. Restaure o INCREMENT BY<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> lab_seq INCREMENT <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- 5. Confirme o reset<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> lab_seq.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Retorna: 1<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- 6. Restaure o MINVALUE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> lab_seq MINVALUE <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Limpeza<\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>DROP SEQUENCE lab_seq;\nDROP TABLE lab_pedidos;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">DROP<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> lab_seq;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">DROP<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> lab_pedidos;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Erros Conhecidos<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">ORA-08004: sequence NEXTVAL goes below MINVALUE and cannot be instantiated<\/h3>\n\n\n\n<p>Ocorre quando o INCREMENT BY negativo levaria o NEXTVAL abaixo do MINVALUE da sequence (padr\u00e3o: 1). Aplicar <code>INCREMENT BY -27<\/code> com NEXTVAL em 27 tentaria pousar em 0, violando o MINVALUE.<\/p>\n\n\n\n<p><strong>Solu\u00e7\u00e3o:<\/strong> Baixe o MINVALUE para 0 antes de aplicar o incremento negativo:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER SEQUENCE lab_seq MINVALUE 0 INCREMENT BY -27 NOCACHE;\nSELECT lab_seq.NEXTVAL FROM dual; -- Retorna: 0\nALTER SEQUENCE lab_seq INCREMENT BY 1;\nALTER SEQUENCE lab_seq MINVALUE 1;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> lab_seq MINVALUE <\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\"> INCREMENT <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #B48EAD\">27<\/span><span style=\"color: #D8DEE9FF\"> NOCACHE;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> lab_seq.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual; <\/span><span style=\"color: #616E88\">-- Retorna: 0<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> lab_seq INCREMENT <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> lab_seq MINVALUE <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">ORA-04007: MINVALUE cannot be made to exceed the current value<\/h3>\n\n\n\n<p>Ocorre quando voc\u00ea tenta restaurar <code>MINVALUE 1<\/code> enquanto o valor atual da sequence \u00e9 0. O Oracle n\u00e3o permite que o MINVALUE seja maior que o valor corrente.<\/p>\n\n\n\n<p><strong>Solu\u00e7\u00e3o:<\/strong> Restaure o <code>INCREMENT BY 1<\/code> primeiro e consuma um NEXTVAL (que entrega 1) antes de ajustar o MINVALUE:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>-- ERRADO \u2014 falha com ORA-04007:\nALTER SEQUENCE lab_seq INCREMENT BY 1 MINVALUE 1;\n\n-- CORRETO \u2014 fa\u00e7a em etapas:\nALTER SEQUENCE lab_seq INCREMENT BY 1;\nSELECT lab_seq.NEXTVAL FROM dual; -- Retorna: 1\nALTER SEQUENCE lab_seq MINVALUE 1;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #616E88\">-- ERRADO \u2014 falha com ORA-04007:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> lab_seq INCREMENT <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\"> MINVALUE <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- CORRETO \u2014 fa\u00e7a em etapas:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> lab_seq INCREMENT <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> lab_seq.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual; <\/span><span style=\"color: #616E88\">-- Retorna: 1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> lab_seq MINVALUE <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Resumo R\u00e1pido<\/h2>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#d8dee9ff;--cbp-line-number-width:calc(2 * 0.6 * 1rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>-- Moderno (19c+): restart simples\nALTER SEQUENCE esquema.seq RESTART;\n\n-- Moderno (19c+): restart para valor espec\u00edfico\nALTER SEQUENCE esquema.seq RESTART START WITH 1000;\n\n-- Cl\u00e1ssico: substitua X pelo NEXTVAL atual\nALTER SEQUENCE esquema.seq MINVALUE 0 INCREMENT BY -X NOCACHE;\nSELECT esquema.seq.NEXTVAL FROM dual;   -- Retorna: 0\nALTER SEQUENCE esquema.seq INCREMENT BY 1;\nSELECT esquema.seq.NEXTVAL FROM dual;   -- Retorna: 1\nALTER SEQUENCE esquema.seq MINVALUE 1;\n\n-- Identity column\nALTER TABLE esquema.tabela\n  MODIFY (coluna GENERATED AS IDENTITY (START WITH 1));<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #616E88\">-- Moderno (19c+): restart simples<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> esquema.seq <\/span><span style=\"color: #81A1C1\">RESTART<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Moderno (19c+): restart para valor espec\u00edfico<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> esquema.seq <\/span><span style=\"color: #81A1C1\">RESTART<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">START<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">WITH<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1000<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Cl\u00e1ssico: substitua X pelo NEXTVAL atual<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> esquema.seq MINVALUE <\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\"> INCREMENT <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\">X NOCACHE;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> esquema.seq.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual;   <\/span><span style=\"color: #616E88\">-- Retorna: 0<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> esquema.seq INCREMENT <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> esquema.seq.NEXTVAL <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dual;   <\/span><span style=\"color: #616E88\">-- Retorna: 1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SEQUENCE<\/span><span style=\"color: #D8DEE9FF\"> esquema.seq MINVALUE <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Identity column<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> esquema.tabela<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">MODIFY<\/span><span style=\"color: #D8DEE9FF\"> (coluna <\/span><span style=\"color: #81A1C1\">GENERATED<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">AS<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">IDENTITY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #81A1C1\">START<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">WITH<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">));<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Refer\u00eancias<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sqlrf\/ALTER-SEQUENCE.html\">Oracle 19c \u2014 ALTER SEQUENCE<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/12.2\/sqlrf\/CREATE-TABLE.html\">Oracle 12c \u2014 Identity Columns<\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n","protected":false},"excerpt":{"rendered":"<p>Voc\u00ea precisa recriar um ambiente de testes, desfazer uma carga de dados ou simplesmente reiniciar a numera\u00e7\u00e3o de uma sequence. Qualquer que seja o motivo, resetar uma sequence no Oracle \u00e9 uma opera\u00e7\u00e3o comum \u2014 e que tem dois caminhos bem diferentes dependendo da vers\u00e3o do seu banco. Este post mostra os dois m\u00e9todos, explica<\/p>\n","protected":false},"author":1,"featured_media":8512,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"resetar sequence oracle","_yoast_wpseo_title":"Resetando Sequences no Oracle | ExecuteStep","_yoast_wpseo_metadesc":"Aprenda a resetar sequences no Oracle com ALTER SEQUENCE RESTART (19c+) e o m\u00e9todo cl\u00e1ssico com INCREMENT BY.","footnotes":""},"categories":[34,174,29],"tags":[315,319,318,317,316],"class_list":{"0":"post-8508","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-oracle","9":"category-troubleshooting","10":"tag-alter-sequence","11":"tag-how-to","12":"tag-identity-column","13":"tag-lab","14":"tag-oracle-sequence"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Resetando Sequences no Oracle | ExecuteStep<\/title>\n<meta name=\"description\" content=\"Aprenda a resetar sequences no Oracle com ALTER SEQUENCE RESTART (19c+) e o m\u00e9todo cl\u00e1ssico com INCREMENT BY.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Resetando Sequences no Oracle | ExecuteStep\" \/>\n<meta property=\"og:description\" content=\"Aprenda a resetar sequences no Oracle com ALTER SEQUENCE RESTART (19c+) e o m\u00e9todo cl\u00e1ssico com INCREMENT BY.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Execute Step\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-31T03:44:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-31T03:44:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/executestep.com\/wp-content\/uploads\/2026\/03\/default_lab.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1380\" \/>\n\t<meta property=\"og:image:height\" content=\"752\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Henrique\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Henrique\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/resetar-sequences-oracle\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/resetar-sequences-oracle\\\/\"},\"author\":{\"name\":\"Henrique\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/7e854882e27693a21f607693465d95aa\"},\"headline\":\"Resetando Sequences no Oracle: RESTART e o M\u00e9todo Cl\u00e1ssico\",\"datePublished\":\"2026-03-31T03:44:28+00:00\",\"dateModified\":\"2026-03-31T03:44:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/resetar-sequences-oracle\\\/\"},\"wordCount\":608,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/7e854882e27693a21f607693465d95aa\"},\"image\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/resetar-sequences-oracle\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/default_lab.png\",\"keywords\":[\"alter-sequence\",\"how-to\",\"identity-column\",\"lab\",\"oracle-sequence\"],\"articleSection\":[\"Oracle\",\"Oracle\",\"Troubleshooting\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/resetar-sequences-oracle\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/resetar-sequences-oracle\\\/\",\"url\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/resetar-sequences-oracle\\\/\",\"name\":\"Resetando Sequences no Oracle | ExecuteStep\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/resetar-sequences-oracle\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/resetar-sequences-oracle\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/default_lab.png\",\"datePublished\":\"2026-03-31T03:44:28+00:00\",\"dateModified\":\"2026-03-31T03:44:30+00:00\",\"description\":\"Aprenda a resetar sequences no Oracle com ALTER SEQUENCE RESTART (19c+) e o m\u00e9todo cl\u00e1ssico com INCREMENT BY.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/resetar-sequences-oracle\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/resetar-sequences-oracle\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/resetar-sequences-oracle\\\/#primaryimage\",\"url\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/default_lab.png\",\"contentUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/default_lab.png\",\"width\":1380,\"height\":752,\"caption\":\"Default Lab\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/resetar-sequences-oracle\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resetando Sequences no Oracle: RESTART e o M\u00e9todo Cl\u00e1ssico\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#website\",\"url\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/\",\"name\":\"Execute Step\",\"description\":\"Execute with precision. Step by step.\",\"publisher\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/7e854882e27693a21f607693465d95aa\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/7e854882e27693a21f607693465d95aa\",\"name\":\"Henrique\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/logo_autor.png\",\"url\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/logo_autor.png\",\"contentUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/logo_autor.png\",\"width\":182,\"height\":173,\"caption\":\"Henrique\"},\"logo\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/logo_autor.png\"},\"sameAs\":[\"https:\\\/\\\/executestep.com\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/henrique-soares-da-silva\\\/\",\"#\"],\"url\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/author\\\/ricuxo\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Resetando Sequences no Oracle | ExecuteStep","description":"Aprenda a resetar sequences no Oracle com ALTER SEQUENCE RESTART (19c+) e o m\u00e9todo cl\u00e1ssico com INCREMENT BY.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/","og_locale":"pt_BR","og_type":"article","og_title":"Resetando Sequences no Oracle | ExecuteStep","og_description":"Aprenda a resetar sequences no Oracle com ALTER SEQUENCE RESTART (19c+) e o m\u00e9todo cl\u00e1ssico com INCREMENT BY.","og_url":"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/","og_site_name":"Execute Step","article_published_time":"2026-03-31T03:44:28+00:00","article_modified_time":"2026-03-31T03:44:30+00:00","og_image":[{"width":1380,"height":752,"url":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/03\/default_lab.png","type":"image\/png"}],"author":"Henrique","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Henrique","Est. tempo de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/#article","isPartOf":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/"},"author":{"name":"Henrique","@id":"https:\/\/executestep.com\/pt-br\/#\/schema\/person\/7e854882e27693a21f607693465d95aa"},"headline":"Resetando Sequences no Oracle: RESTART e o M\u00e9todo Cl\u00e1ssico","datePublished":"2026-03-31T03:44:28+00:00","dateModified":"2026-03-31T03:44:30+00:00","mainEntityOfPage":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/"},"wordCount":608,"commentCount":0,"publisher":{"@id":"https:\/\/executestep.com\/pt-br\/#\/schema\/person\/7e854882e27693a21f607693465d95aa"},"image":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/03\/default_lab.png","keywords":["alter-sequence","how-to","identity-column","lab","oracle-sequence"],"articleSection":["Oracle","Oracle","Troubleshooting"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/","url":"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/","name":"Resetando Sequences no Oracle | ExecuteStep","isPartOf":{"@id":"https:\/\/executestep.com\/pt-br\/#website"},"primaryImageOfPage":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/#primaryimage"},"image":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/03\/default_lab.png","datePublished":"2026-03-31T03:44:28+00:00","dateModified":"2026-03-31T03:44:30+00:00","description":"Aprenda a resetar sequences no Oracle com ALTER SEQUENCE RESTART (19c+) e o m\u00e9todo cl\u00e1ssico com INCREMENT BY.","breadcrumb":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/#primaryimage","url":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/03\/default_lab.png","contentUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/03\/default_lab.png","width":1380,"height":752,"caption":"Default Lab"},{"@type":"BreadcrumbList","@id":"https:\/\/executestep.com\/pt-br\/oracle\/resetar-sequences-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/executestep.com\/pt-br\/"},{"@type":"ListItem","position":2,"name":"Resetando Sequences no Oracle: RESTART e o M\u00e9todo Cl\u00e1ssico"}]},{"@type":"WebSite","@id":"https:\/\/executestep.com\/pt-br\/#website","url":"https:\/\/executestep.com\/pt-br\/","name":"Execute Step","description":"Execute with precision. Step by step.","publisher":{"@id":"https:\/\/executestep.com\/pt-br\/#\/schema\/person\/7e854882e27693a21f607693465d95aa"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/executestep.com\/pt-br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":["Person","Organization"],"@id":"https:\/\/executestep.com\/pt-br\/#\/schema\/person\/7e854882e27693a21f607693465d95aa","name":"Henrique","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/logo_autor.png","url":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/logo_autor.png","contentUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/logo_autor.png","width":182,"height":173,"caption":"Henrique"},"logo":{"@id":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/logo_autor.png"},"sameAs":["https:\/\/executestep.com","https:\/\/www.linkedin.com\/in\/henrique-soares-da-silva\/","#"],"url":"https:\/\/executestep.com\/pt-br\/author\/ricuxo\/"}]}},"_links":{"self":[{"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/posts\/8508","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/comments?post=8508"}],"version-history":[{"count":0,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/posts\/8508\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/media\/8512"}],"wp:attachment":[{"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/media?parent=8508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/categories?post=8508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/tags?post=8508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}