-
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?
-
-
Originally Posted by steeve123
How can i say the impdp utility to just import the triggers?
Take a look at the INCLUDE parameter of the impdp.
http://download-uk.oracle.com/docs/c....htm#sthref308
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Thanks: include=trigger worked
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|