Import Defer Referential Contraint Checks
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Import Defer Referential Contraint Checks

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343

    Import Defer Referential Contraint Checks

    I need to import some data into already existing tables. As the import normally happens in the alphabetical order of the table names, I am getting referential constraint errors during the import process. I can disable the referential constraints before import and then enable them once the import is complete, but that could take a while as this is a big DB. Any other way to acheive this ?

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Ese separate import files that let you guarantee the import order? Run the import multiple times, specifying different tables each time to guarantee the import order?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    lists the tables in the order you want in the TABLES= parameter of imp

    diable constraints wont take too much time though, and if you are sure of the data enable them with novalidate etc

  4. #4
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Looks like that is what I have to do.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width