Home » SQL & PL/SQL » SQL & PL/SQL » Disabling procedures and triggers (Win 2003, 9i)
Disabling procedures and triggers [message #303624] Sat, 01 March 2008 04:46 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

Is there is a single statement to disable all the constraints and triggers of a schema rather than writing a script for it

- Das
Re: Disabling procedures and triggers [message #303626 is a reply to message #303624] Sat, 01 March 2008 04:51 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
http://www.orafaq.com/forum/m/199329/94420/?srch=disable+all+the+constraints#msg_199329

Please try to use the search button.

Regards

Raj
Re: Disabling procedures and triggers [message #303631 is a reply to message #303626] Sat, 01 March 2008 05:11 Go to previous message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks
Previous Topic: How to export objects from Access 2003 to oracle 11g ?
Next Topic: Error while passing Filename and path to Stored Procedure
Goto Forum:
  


Current Time: Sat Dec 10 10:56:33 CST 2016

Total time taken to generate the page: 0.11436 seconds