首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 开发语言 > Ruby Rails >

ORA-00604: error occurred at recursive SQL level 一,ORA-00942: table or view does

2012-12-23 
ORA-00604: error occurred at recursive SQL level 1,ORA-00942: table or view does点击右边红色标题查

ORA-00604: error occurred at recursive SQL level 1,ORA-00942: table or view does
点击右边红色标题查看本文完整版:ORA-00604: error occurred at recursive SQL level 1,ORA-00942: table or view does not exist

SQL> drop user HR cascade;
drop user HR cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
------解决方法--------------------
Cause:An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).

在运行一条递归SQL语句(该语句将应用于对内部表或数据字典的操作)时,发生错误。这样的错误好头疼啊.楼主可以先drop该用户下的所有对象,然后在drop这个空用户.

------解决方法--------------------
Create a synonym for SDO_GEOM_METADATA_TABLE under sys which points to
MDSYS.SDO_GEOM_METADATA_TABLE

    

热点排行