Printable View
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..
compilation errors.
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
thanks
sat
the trigger i tried to create was like this
create or replace trigger user_priv
before create or drop on database
begin
if ( user in ( 'PVNET') )
then
raise_application_error( -20001,
'You are not allowed to do this' );
end if;
end;
----------------------
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.
thanks folks
Hi sat,
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...!
HTH,
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?