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 -> Disabling All Triggers and Foreign Key Constraints

Disabling All Triggers and Foreign Key Constraints

From: Tom Schindl <tomAtLinux_at_gmx.at>
Date: Fri, 14 Apr 2006 13:59:59 +0200
Message-ID: <443f8ec0$0$32395$79720d31@newsreader.inode.at> 





Hi,



is it possible to enable disable/enable all triggers and foreign key
constrainst defined on a table.



I've tried:


  alter table BLA disable all trigger.



But this gives me a "ORA-01735: invalid ALTER TABLE option"



Thanks



Tom
Received on Fri Apr 14 2006 - 06:59:59 CDT












Original text of this message













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