Disable sequencing in Oracle 10g

Posted on 2007-07-25
Last Modified: 2013-12-18
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.
Question by:dlnewman70
    LVL 22

    Expert Comment

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

    Expert Comment

    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.

    LVL 9

    Accepted Solution

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    Oracle View 13 34
    select query - oracle 16 57
    oracle query help 36 38
    querying by the sum of a column in decimal 7 28
    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    This video shows how to recover a database from a user managed backup

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now