ORA-00604 ORA-21700錯誤處理

來源:互聯網
上載者:User

ORA-00604 ORA-21700錯誤處理

今天刪除SDE使用者(GIS地圖資料使用者)報ORA-00604 ORA-21700,詳細處理步驟如下:

SQL>  drop user SDE cascade; 

ERROR  at line 1:
 ORA-00604:error occurred at recursive SQL level 2
 ORA-21700:object does not exist or is marked for delete

SQL>  select user_id,username from dba_users where username  = 'SDE';

  USER_ID USERNAME
 ---------- ------------------------------
        123 SDE
       
 SQL> select  o.name,a.* from association$ a,obj$ o where a.obj#=o.obj# and o.OWNER# = 123;
 

NAME                                OBJ#  PROPERTY    INTCOL# STATSTYPE# DEFAULT_SELECTIVITY DEFAULT_CPU_COST DEFAULT_IO_COST DEFAULT_NET_COST INTERFACE_VERSION#    SPARE2
 ------------------------------ ---------- ---------- ---------- ---------- ------------------- ---------------- --------------- ---------------- ------------------ ----------
 ST_GEOMETRY                        114471          2                114478                                                                                        2          0

SQL> delete from association$ where obj#=114471;

1 row deleted.

SQL>  drop user SDE cascade;

User dropped.

--------------------------------------分割線 --------------------------------------

在CentOS 6.4下安裝Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虛擬機器中安裝步驟

Debian 下 安裝 Oracle 11g XE R2

--------------------------------------分割線 --------------------------------------

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.