How to Drop an Orphan LOB in Oracle Database – Make DBA Life Easy
In Oracle 11.2.0.3 database, after dropped some tables, there are still lob objects in dba_objects and dba_segments. Find the table name the lob belongs to: SQL> show parameter recyclebinNAME TYPE VALUE------------------------------------ ----------- -----------------------recyclebin string on SQL> select u.name, o.name TABLENAME, decode(bitand(c.property, 1), 1, ac.name, c.name) as column_name from sys.obj$ o, sys.col$ c, sys.attrcol$ ac,sys.lob$ l,sys.obj$…
