Oracle-L: RE: Reverse Engineering Triggers

From: Richard Huntley <rhuntley_at_mindleaders.com>
Date: Tue, 18 Jun 2002 12:23:22 -0800
Message-ID: <F001.004809E8.20020618122322@fatcity.com>

Steve,
I don't have a handy script, but if you're using 9i, you could easily create something that just spools the output of

select dbms_metadata.get_ddl('TRIGGER',trigger_name) FROM USER_TRIGGERS;

then just run the spool file

-----Original Message-----
Sent: Tuesday, June 18, 2002 3:00 PM
To: Multiple recipients of list ORACLE-L

Anyone have a handy-dandy script to create a script which recreates triggers? (By querying user/dba_triggers.)

Member of the Wheel Reinvention Prevention Society, Steve Orr
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Orr, Steve
INET: sorr_at_rightnow.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Richard Huntley
INET: rhuntley_at_mindleaders.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------