Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Why cannot drop user?
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
begin 666 frown.gif
M1TE&.#EA#P`/`)$``````+V]O8RM_[V]O2'Y! $```,`+ `````/``\```(O
MG V9QY,"X6) QBK P?A*E$5BI76/9*:7*K:K"Y^H,CK6^-GPM>U9(T,U-_at_H-
$HP``.P``
`
end
Received on Tue Jan 28 2003 - 00:30:25 CST
![]() |
![]() |