ORA-00604 ORA-21700 error handling

ORA-00604 ORA-21700 error handling

Delete SDE user (GIS map data user) report ORA-00604 ORA-21700 today, detailed steps are as follows:

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_selecti.pdf 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.

-------------------------------------- Split line --------------------------------------

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

-------------------------------------- Split line --------------------------------------