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