Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to set trigger status "valid" on Oracle 9i
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...Received on Thu Feb 07 2002 - 09:44:08 CST
> 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.
![]() |
![]() |