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: Trigger at the Schema level - not working

Re: Trigger at the Schema level - not working

From: Thomas Kellerer <spam_eater_at_gmx.net>
Date: Tue, 23 Dec 2003 10:07:49 +0100
Message-ID: <bs90lb$apksk$1@ID-13919.news.uni-berlin.de>


Jawahar Rajan schrieb:

> All,
> I am trying to use the following trigger. It is a Schema level trigger, that
> should run each time a table is created.
> I am trying to create a shadow table for eachnew table created. However I
> get an error that say I do not have permissions?
>
> Any ideas why
> The error:
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01031: insufficient privileges
> ORA-06512: at line 39
>
> Do I need tobe a DBA to get the trigger to fire?
> Any Suggestions welcome
>
> Jawahar

I'm not familiar with schema level triggers, so maybe there is something I'm missing, but wouldn't your trigger cause an infinite loop?

You are creating a table in there which in turn, will fire the trigger which will create a shadow table for your shadow table and so on...

Thomas Received on Tue Dec 23 2003 - 03:07:49 CST

Original text of this message

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