about invalid trigger
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: about invalid trigger

  1. #1
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87
    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
    sat

  2. #2
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87

    tamil/pando/jmagnus/pls look

    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

    sat

  3. #3
    Join Date
    Mar 2000
    Location
    Toronto, Ontario, Canada
    Posts
    213

    Disable it if possible!

    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,

    Regards,
    Vimal Patel
    OCP DBA 7.3, 8, 8i, 9i
    Sun Solaris 8 Sys. Admin.
    A+

  4. #4
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    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

    Thanks
    Kishore Kumar

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width