-
ORA-30506 error trying to create trigger
I'm running Oracle 9i, and trying to create a database-level trigger after startup. Database name is DKDB. Here is the beginning of the trigger code:
CREATE TRIGGER PurgeOnStartup
AFTER STARTUP ON DKDB
And here is the error:
AFTER STARTUP ON DKDB
*
ERROR at line 2:
ORA-30506: system triggers cannot be based on tables or views
I have not created any tables or views named DKDB. I'm logged in with DBA privs. I've already logged in as sys and ran dbmsstdx.sql, What am I doing wrong?
Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|