lob表删除后dba_objects信息仍在

今天在删除带有Lob字段的表后发现个问题，表的定义已经没有了，但Lob信息仍然保留在dba_objects中，后经查找mos将回收站清理后不复存在

13:05:23 ljc1>select * from v$version;

BANNER CON_ID

---

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
CORE 12.1.0.2.0 Production 0
TNS for HPUX: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0

13:06:03 ljc1>select ‘drop ‘|| object_type||’ ‘||owner||’.’||object_name||’ ;’ from dba_objects
13:06:13 2 where owner =‘DBA_XJL’ ;

drop LOB DBA_XJL.SYS_LOB0000255706C00022;
drop LOB DBA_XJL.SYS_LOB0000235936C00022 ;
drop LOB DBA_XJL.SYS_LOB0000235942C00022 ;
drop LOB DBA_XJL.SYS_LOB0000235945C00022 ;
drop LOB DBA_XJL.SYS_LOB0000235948C00022 ;
drop LOB DBA_XJL.SYS_LOB0000235951C00022;
drop LOB DBA_XJL.SYS_LOB0000235954C00022 ;
drop LOB DBA_XJL.SYS_LOB0000235957C00022 ;

13:06:51 ljc1> select owner,table_name,column_name,segment_name from dba_lobs where owner=‘DBA_XJL’;

no rows selected

–清理回收站后信息不复存在

13:07:03 ljc1> select ‘drop ‘|| object_type||’ ‘||owner||’.’||object_name||’ ;’ from dba_objects
2 where owner in (‘WH_LUOTINGDAN’,‘WH_JUYING’,‘WH_SUNLU’,‘WH_JIANGGUOFENG’,‘WH_WANGZEXUAN’,‘DBA_XIUJILONG’,‘DBA_XJL’,‘WH_SUNYAN’,‘WH_ZHANGRUI’,‘WH_LIUTONGCHUAN’) ;

no rows selected

参阅Mos
Drop Table Does Not Remove The Blob LobIndex Segment (文档 ID 394442.1)