Re: script to dynmically create all foreign key constraints

smontgomerie_at_hotmail.com (Steve) wrote in message news:<156709aa.0212101828.5c08a5a_at_posting.google.com>...
> hey there,
> anyone have a script handy that generates sql to create all the
> foreign key's in the database? Our client does not like ON DELETE
> CASCADE to be left on. However, once in a while we need to use that
> functionlity so I as going to drop the FK's in restricted session,
> recreate them with ON DELETE CASCADE, perform the operation what
> requires DELETE CASCADE, and then drop and recreate the FK's without
> ON DELETE CASCADE. I know this sounds kind of hokey but the ON DELETE
> CASCADE functionality is only ever required once every odd month so. I
> know I can get the constraints from import export but I'd like a
> dynaminc sql that I can just edit one and run.

Some real handy scripts on http://metalink.oracle.com .

Click on Top Tech Docs --> Database --> Storage --> Scripts

jg

--
@home is bogus.
"As always, Oracle's worst threat is itself.  Like pushing Information
Appliances instead of Linux." - Me, 07-Dec-1999.