Database Administration (MOSC)

MOSC Banner

Object exists in dba_objects but nowhere else

edited Sep 20, 2016 5:00AM in Database Administration (MOSC) 8 commentsAnswered

Hi,

We have an index named QUEST_SX_IDX***** which exists in dba_objects as a valid index object but doesn't exists in dba_indexes.

We started to check if the object was dropped and was actually in the recycle bin but we couldn't find it there either.

The problem is that this index refers a table in another tablespace which we are trying to export through transportable tablespaces and of course this index comes up in the integrity check.
However we cannot get rid of this index. Dba_objects thinks it's valid but we cannot find it in dba_indexes nor in the recycle bin and thus cannot drop it.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center