Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> sys trigger error
Hi
I just set up a database 817 on NT4 using the database wizard.
Created a test user and created a table. When I try to drop the user or
the table I get
ORA-04098: trigger 'SYS.JIS$ROLE_TRIGGER$' is invalid and failed re-validation.
does this mean that I missed something out in the set up of the database, something like the catlog or catproc scripts as I thought that
these were automatically run from the wizard.
The solution in the Oracle books says disable or drop the trigger? but surely this cant be the correct way to fix the problem as this is a system owed trigger.
Any thoughts would be appreciated. Received on Wed Sep 12 2001 - 05:05:16 CDT