Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

"orphan" lobsegment

Hi all.

After completion of the reorganization of the tablespace was one lobsegment.
I can not drop or move it. I can not drop the tablespace also (ORA-22868: table with LOBs contains segments in different tablespaces).
Oracle 10.2.0.2.

SQL> select SEGMENT_NAME,SEGMENT_TYPE from dba_segments where tablespace_name = 'PSAPI01';

SEGMENT_NAME                         SEGMENT_TYPE
----------------------------------------------
SYS_IL0000275664C00016$$       LOBINDEX
SYS_LOB0000275664C00016$$      LOBSEGMENT

SQL> select OBJECT_NAME, OBJECT_TYPE from DBA_OBJECTS where OBJECT_NAME LIKE '%275664C%' or SUBOBJECT_NAME LIKE '%275664C%';

OBJECT_NAME                    OBJECT_TYPE
------------------------------------------------------------------------------------
SYS_LOB0000275664C00016$$      LOB

BUT:

SQL> SELECT * FROM ALL_LOBS WHERE segment_name LIKE '%275664C%';
no rows selected

SQL> SELECT * FROM DBA_LOBS WHERE segment_name LIKE '%275664C%';
no rows selected

SQL> SELECT * FROM USER_LOBS WHERE segment_name LIKE '%275664C%';
no rows selected

SQL>  select * from RECYCLEBIN;

no rows selected

Regards.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question