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

Thread: Import Question

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    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?

    Jigar
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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)."
    HTH
    Jim
    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