import everything except the triggers!!
I did a full export of the database with the new export utility from 10g.
expdp userid=sys dumpfile=full.dmp full=y
When i imported in a new database. Everything was ok, except the owners dont have any table triggers
impdp userid=sys dumfile=full.dmp full=y
impdp userid=sys dumfile=full.dmp schemas=demo40
Both commands did not import the table trigger.
Is there a way to import only the trigger?
Why this happened?
Note: I did this with 10.2.0.1
I patched the database to 10.2.0.2.0 this weekend.
Do you think the patched version will import the triggers?
Click Here to Expand Forum to Full Width