• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3128
  • Last Modified:

Disable sequencing in Oracle 10g

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.
1 Solution
You could get the current value, drop the Sequence, do your inserts and rebuild the sequence starting where it where it left off.
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.

Agree.  You probably have a TRIGGER for the table that has an ON INSERT condition.  Disable it and you should be fine.

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now