<div>
You could get the current value, drop the Sequence, do your inserts and rebuild the sequence starting where it where it left off.
</div>


You could get the current value, drop the Sequence, do your inserts and rebuild the sequence starting where it where it left off.

<div>
There is no such option in Oracle to disable sequence. <br />
<br />
Is sequence used by any other objects in your database? you may want to check the dependency of the sequence before removing it from the database. <br />
<br />
<br />

</div>


There is no such option in Oracle to disable sequence.

Is sequence used by any other objects in your database? you may want to check the dependency of the sequence before removing it from the database.




<div>
<div class="content wysiwyg-content">
Is there any method that I could use to turn off sequencing associated with a table in Oracle 10g? I am trying to load the contents of one file to another database using insert statements, but I don't want the target table to auto increment. I want it to take the exact same contents but the problem is it autoincrements and violates certain constraints. If it loaded the exact same data it would work.
</div>
</div>


Is there any method that I could use to turn off sequencing associated with a table in Oracle 10g? I am trying to load the contents of one file to another database using insert statements, but I don't want the target table to auto increment. I want it to take the exact same contents but the problem is it autoincrements and violates certain constraints. If it loaded the exact same data it would work.

Disable sequencing in Oracle 10g

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.