Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.Received on Wed Dec 11 2002 - 17:34:52 CST