Failed Logon Trigger on DATABASE

I am playing around with trigger (luckily in a test machine) and now cannot login anymore (even sys). Could anyone help me to resolve the problem.

Using 'user1' account, I defined a DDL trigger for logon to log all user's logon:

CREATE OR REPLACE TRIGGER all_user_logon   AFTER LOGON ON DATABASE
BEGIN
  INSERT INTO scott.user_session_log (user_log_id, username, action_type,action_dt)

     VALUES (user_log_id_SEQ.NEXTVAL, USER, 'LOGON', SYSDATE); END; Unfortunately, I forgot to grant 'user1' insert right for scott's table and the above trigger always fails whenever someone logon (including SYS). Now I got this error whenever I try to logon with iSQLPLUS and the logon attempt fails:

ERROR:
ORA-00600: internal error code, arguments: [4406], [0x67B7F044],
[0x67B7F420], [], [], [], [], []

ORA-00600: internal error code, arguments: [17034], [0x31C3274], [0], [],
[], [], [], []

Is there anyway to disable the trigger without logon? Received on Tue Jul 05 2005 - 03:44:58 CDT