Re: Capture DDL for Triggers

In our last gripping episode "Eric Givler" <egivler_at_flash.net> wrote:
> Does anyone have a SQL/pl/sql script to capture the ddl for
 recreating the
> triggers for a given schema? I saw one on Oracle's Metalink, but it
 does
> not properly capture the column usage information - ie. for update of
 column
> lists. Ideally, it should capture each trigger into a separate file:
> triggername.sql
>
> That's about it.
>
>

Usually the trigger code is in the original scripts they were installed from. Possibly those are "lying about" somewhere; they should be. I would ask around for those before trying to extract the information from the database.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.