Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: disabling and enabling all constraints

Re: disabling and enabling all constraints

From: David Sisk <davesisk_at_ipass.net>
Date: Sat, 15 Aug 1998 18:33:45 GMT
Message-ID: <dwkB1.901$yo1.26606234@news.ipass.net>


Hi:

If you haven't recreated all the tables (just the database itself) then why don't you just use import?

Good luck,
Dave

David Chasteen wrote in message <6r247d$utr$1_at_samsara0.mindspring.com>...
>I want to load data back into a recreated database without worrying about
>referential integrity. The data was validated when it was input and will
>not be changed before being run back into the database.
>
>Is there a simple command to disable all constraints in the database so I
>can run the data back in without concern for table load order?
>
>I can't seem to find a clear reference and have not been able to do
anything
>other than constraints one at a time.
>
>Thank you,
>
>David
>
>
Received on Sat Aug 15 1998 - 13:33:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US