Re: Why cannot drop user?

yikaikai wrote:

> Hi all, I try it:
> SQL>connect / as sysdba
> SQL> drop user zyk cascade;
> drop user zyk cascade
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00942: table or view does not exist
>
> I know system user had delete the user's access$ table
>
> SQL> connect zyk/zyk
> ERROR:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00942: table or view does not exist
> ORA-06512: at line 5
>
> That's the trc file:
>
> Dump file e:\ora_prog\zyk\udump\zyk_ora_2368.trc
> Mon Jan 27 18:12:27 2003
> ORACLE V9.2.0.1.0 - Production vsnsta=0
> vsnsql=12 vsnxtr=3
> Windows 2000 Version 5.0 Service Pack 3, CPU type 586
> Oracle9i Release 9.2.0.1.0 - Production
> JServer Release 9.2.0.1.0 - Production
> Windows 2000 Version 5.0 Service Pack 3, CPU type 586
> Instance name: zyk
>
> Redo thread mounted by this instance: 1
>
> Oracle process number: 12
>
> Windows thread id: 2368, image: ORACLE.EXE
>
> *** SESSION ID9.7) 2003-01-27 18:12:27.000
> Error in executing triggers on connect internal
> *** 2003-01-27 18:12:27.000
> ksedmp: internal or fatal error
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00942: table or view does not exist
> ORA-06512: at line 5
>
> [Image]

Access$ is owned by SYS. Please clarify what is going on. Why would a user have a table by that name? Or did someone delete a table owned by SYS? Daniel Morgan Received on Tue Jan 28 2003 - 10:53:33 CST