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?
Were the triggers owned by the same user as the tables, and have you checked that they were contained in the export file?
The trigger are owned by the user.
The first 2 import i did where fine. I imported it with the user sys.
The other import did not imported the triggers. I did not imported with the user sys. Another user, that may not have every privilege to import.
So if i try to re-import with the user sys, the triggers still wont import. How can i say the impdp utility to just import the triggers?
Take a look at the INCLUDE parameter of the impdp.
Originally Posted by steeve123
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Thanks: include=trigger worked
Click Here to Expand Forum to Full Width