ORA-21700:object does not exist or is marked for delete 分析原因:先删除表空间,后删除用户,导致系统表中包含有SDE用户的信息。从而导致SDE用户删除不了。 解决方法: 在系统表association$中查看是否有包含sde的东西,如果有删除掉。 比如:select o.name,a.* from association$ a,obj$ o where a.obj#=o.o...
删除SDE用户(GIS地图数据用户)，长时间删除没反应，结束dropusersdecascade命令后，重新执行，结果报ORA-00604 ORA-21700，结果学习，将详细处理步骤写出。方法/步骤 1 运行cmd命令，进入sqlplus 2 执行删除sde用户命令：drop user SDE cascade;3 结果发现报错，执行语句：select user_id,username from dba_users where...
ORA-21700:object does not exist or is marked for delete 分析原因:先删除表空间,后删除用户,导致系统表中包含有SDE用户的信息。从而导致SDE用户删除不了。 解决方法: 在系统表association$中查看是否有包含sde的东西,如果有删除掉。 比如:select o.name,a.* from association$ a,obj$ o where a.obj#=o.o...
删除SDE用户报ORA-00604 ORA-21700 引自:https://jingyan.baidu.com/article/656db918d6b81be381249cde.html 删除SDE用户(GIS地图数据用户),结果报ORA-00604 ORA-21700。 解决方法: 1、执行语句: select user_id,username from dba_users where username = 'SDE'; 2、根据对应的检索值,执行命令:select o....
1 Oracle 12.2的重磅特性及发布时间 2016年2月，Oracle出了12.2的beta2版本，并 ...
Oracle HTTP Server - Version 12.1.3.0.0 and later: "ORA-21700: Object Does Not Exist Or Is Marked For Delete" After Upgrade To 12.2 for Mod_plsql Application
2. Try to drop the tables in other schemas using the SDE.ST_GEOMETRY type Get also error ORA-21700: object does not exist or is marked for delete 3. Back to SDE and try to drop the SDE.ST_GEOMETRY type gives error ORA-21700: object does not exist or is marked for delete ...
ORA-21700通常表示试图非法使用PL/SQL对象（如集合或定位器）的操作。在您的情况下，错误可能是由于...
--- --- --- --- ST_GEOMETRY 78940 2 78990 2 0 SQL> delete from association$ where obj#= 78940; 已删除 1 行。 SQL> drop user SDE cascade; 用户已删除。 SQL>
ORA-21700: object does not exist or is marked for deleteSQL> drop user TEST_USER cascade;drop user TEST_USER cascade*ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1ORA-21700: object does not exist or is marked for delete...