There's lots of info on Metalink about this one. Just search for
"ROLE_TRIGGER"
-Kevin
"Simon Cunningham" <cs40_at_gre.ac.uk> wrote in message
news:3B9F335C.A55F7294_at_gre.ac.uk...
> 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 - 12:06:16 CDT
