Folks very urjent
I tried to create a trigger but unfortunately i did with spelling mistakes and it returned compilation error.
when i tried to do this after modification it rtnd error 04098.
Now i tried to drop the same but its not allowing me to do..
now i need to create some new tables even then its not allowing me to do.
what could be done now..
i restared the db and tried to drop trigger which was invalid but not possible..pls advice very urgemnt
the trigger i tried to create was like this
create or replace trigger user_priv
before create or drop on database
if ( user in ( 'PVNET') )
'You are not allowed to do this' );
and the error its now giving is
create table t(x number)
ORA-04098: trigger 'DDL_TRIGGER' is invalid and failed re-validation
SVRMGR> !oerr ora 4098
04098, 00000, "trigger '%s' is invalid and failed re-validation"
// *Cause: A trigger was attempted to be retrieved for execution and was
// found to be invalid. This also means that compilation/authorization
// failed for the trigger.
// *Action: Options are to resolve the compilation/authorization errors,
// disable the trigger, or drop the trigger.
Disable it if possible!
i'm not expert, if i'm wrong please excuse me!
Did you try to disable the trigger?
than you can try to drop it...!
OCP DBA 7.3, 8, 8i, 9i
Sun Solaris 8 Sys. Admin.
Possible reason, when you try to create the trigger, you might have enterd some spaces after or before the trigger name
May be if you have OEM installed, just go to that and drop it with GUI facility
look, I think itīs referring DDL_TRIGGER not USER_PRIV trigger
try to recompile it, what error you get when you try to drop it?
Click Here to Expand Forum to Full Width