Oracle ORA-1561 Missing Rows In tables – Example 3 Seg$ with no entries in obj$,ind$

Posted by PDSERVICE on Nov 14, 2015 In

Missing Rows In tables – Example 3

Seg$ with no entries in obj$,ind$

Dropping the tablespace produces error ORA-1561:

SQL> drop tablespace test_dict_corr including contents and datafiles;

drop tablespace test_dict_corr including contents and datafiles

ERROR at line 1:

ORA-01561: failed to remove all objects in the tablespace specified

No rows in dba_segments:

SQL> select * from dba_segments where tablespace_name = 'TEST_DICT_CORR';

no rows selected

One row in seg$:

SQL> select ts#, name from v$tablespace where name = 'TEST_DICT_CORR';

TS# NAME

---------- ------------------------------

20 TEST_DICT_CORR

SQL> Select ts#, file#, block#, type# from seg$ where ts#=20;

TS# FILE# BLOCK# TYPE#

---------- ---------- ---------- ----------

20 7 17 6 ----à type#=6 (INDEX).

Hcheck8i output:

Problem: Orphaned SEG$ Entry

ORPHAN SEG$: SegType=INDEX TS=20 RFILE/BLOCK=7 17

No orphaned IND$ entries

You are here