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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to set trigger status "valid" on Oracle 9i

Re: How to set trigger status "valid" on Oracle 9i

From: Syltrem <syltrem_at_videotron.spammenot.ca>
Date: Thu, 7 Feb 2002 10:44:08 -0500
Message-ID: <bhx88.4011$EI.21632@tor-nn1.netcom.ca>


alter trigger xxx compile ?

dunno about 9i. Works on 8i

--

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove .spammenot from my address

"odette" <odette.h_at_gmx.de> a écrit dans le message de news:
66e0618e.0202070737.5ecd557b_at_posting.google.com...

> I've created an insert trigger on a database table, but the trigger
> status is invalid! Who can tell me, how I can change the status to
> valid? I just tried to alter the trigger via sql*plus worksheet, but
> this had no effect.
Received on Thu Feb 07 2002 - 09:44:08 CST

Original text of this message

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