Skip to Main Content

SQL & PL/SQL

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!

trigger dump

koszta5Jan 24 2011 — edited Jan 24 2011
Hi folks,
how do I export triggers only from Oracle DB? Or can I just somehow use dbms_metadata.GET_DDL function to get their ddl ? I need to see what they are doing...

I would really love to know how to export those only since my DB is quite large and I dont want to parse the whole GIANT file to search for a small trigger...


thanks...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2011
Added on Jan 24 2011
5 comments
633 views