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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Disable all constraints and triggers in entire schema.

Re: Disable all constraints and triggers in entire schema.

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Wed, 14 Nov 2007 03:58:10 GMT
Message-ID: <mnu_i.3668$aN3.1576@newsfe12.phx> 





Sean Nakasone <seannakasone_at_yahoo.com> wrote in
news:Pine.WNT.4.64.0711131416001.984_at_ctfanxnfba.unjnvvnaryrpgevp.arg: 



> Is there a way to disable all contraints and triggers in all the

> tables in a particular schema? Either through toad or sql.

> 




yes, write SQL to write SQL & issue th DISABLES
Received on Tue Nov 13 2007 - 21:58:10 CST












Original text of this message













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