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

Re: Disabling All Triggers and Foreign Key Constraints

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 14 Apr 2006 08:37:10 -0400
Message-ID: <Au2dnUVpVJvnCqLZnZ2dnUVZ_vSdnZ2d@comcast.com> 






"Tom Schindl" <tomAtLinux_at_gmx.at> wrote in message 
news:443f8ec0$0$32395$79720d31_at_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




you've got a typo. did you check the SQL manual?



++ mcs 
Received on Fri Apr 14 2006 - 07:37:10 CDT












Original text of this message













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