DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Import Question

  1. #1
    Join Date
    Aug 2000
    Chicago IL

    Import Question

    I am wondering...
    An export was taken from a full schema level export that includes all the objects..triggers/constraints etc..

    so when we import that dmp file into another database or schema and while that import is running do the triggers gets enabled before data gets imported or do triggers/constraints get enabled at the end of the import?

    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Jan 2002
    Up s**t creek
    The triggers on a table are created and enabled once the data has been loaded.

    from the manuals:

    First, new tables are created. Then, data is imported and indexes are built. Then triggers are imported, integrity constraints are enabled on the new tables, and any bitmap, functional, and/or domain indexes are built. This sequence prevents data from being rejected due to the order in which tables are imported. This sequence also prevents redundant triggers from firing twice on the same data (once when it was originally inserted and again during the import)."
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.