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?
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"