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