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 -> disabling and enabling all constraints

disabling and enabling all constraints

From: David Chasteen <davidc_at_opteamasoft.com>
Date: Fri, 14 Aug 1998 15:45:35 -0400
Message-ID: <6r247d$utr$1@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 Fri Aug 14 1998 - 14:45:35 CDT












Original text of this message













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