Re: Capture DDL for Triggers

This application was developed under contract and I suppose they MAY have had a designer repository at one time, but when their database architect left, all Heck broke loose. We're still trying to clean things up. Out of 178 tables, only 20 FK relationships exist and only 29 tables have primary keys.

I was hoping to capture all source and object recreation scripts to file just to look through it. I "tweaked" metalink's trigger script a little bit, but I wanted to compare it to someone else's trigger extract code. Is there another tool that will do this?

Would you like me to send you the scripts to verify the output (sql)?

"David Fitzjarrell" <oratune_at_aol.com> wrote in message news:8ts2k6$80m$1_at_nnrp1.deja.com...
> 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.
Received on Sun Nov 05 2000 - 17:38:01 CST