Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DDL of trigger

oradba11Jan 4 2012 — edited Jan 4 2012
Hello,
I am working on 11g and os is AIX.
I was doing an import using data pump , but because of synonyms issues some triggers were not able to import .
Now i need to create those triggers again but in import dump files are no full create trigger syntex recorded.
I tried to create create trigger script using sqlfile option but in sqlfile oracle is not creating create trigger syntex.
I do not have source database access , is there any other way to get DDL of create trigger from export dump file.

any idea...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2012
Added on Jan 4 2012
8 comments
456 views