17,377
社区成员
发帖
与我相关
我的任务
分享怎么解决以下问题．删用户时报以下错．
[oracle@Linux1 ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.7.0 - Production on Fri Apr 18 16:23:48 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> drop user ccatsupt cascade;
drop user ccatsupt cascade
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
SQL*Plus: Release 9.2.0.7.0 - Production on Fri Apr 18 16:23:48 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> drop user ccatsupt cascade;
drop user ccatsupt cascade
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
...全文
请发表友善的回复…
发表回复
genispan 2008-04-18
- 打赏
- 举报
Fix
Run the script catmd.sql (located in $ORACLE_HOME/md/admin dir).
The catmd.sql script is the script that loads all objects needed by Oracle spatial in the
database. Then drop the user.
楼上的地址已经详细说明了 我转帖过来的 可以去看看
Run the script catmd.sql (located in $ORACLE_HOME/md/admin dir).
The catmd.sql script is the script that loads all objects needed by Oracle spatial in the
database. Then drop the user.
楼上的地址已经详细说明了 我转帖过来的 可以去看看
TodayZ 2008-04-18
- 打赏
- 举报
FYI: http://zhydyt.spaces.live.com/blog/cns!f065e15da80cfaa9!241.entry
