Database Administration (MOSC)

MOSC Banner

Table missing in dba_tables but visible in dba_segments & dba_objects

edited Aug 3, 2010 10:22AM in Database Administration (MOSC) 22 commentsAnswered ✓
 Hi

I was trying to weed out some invalid objects and came up on some interesting situation.

I have six tables that show up as INVALID

select * from dba_objects where status = 'INVALID' and object_type = 'TABLE' * from dba_objects where status = 'INVALID' and object_type = 'TABLE'

But when I try to drop them it says Table or View does not exist.

select * from dba_tables where table_name like upper('OrderLifetime418_TAB') * from dba_tables where table_name like upper('OrderLifetime418_TAB')

does not return any row.

where as dba_objects shows that object of TABLE type as INVALID and also dba_segments return the above object as SEGMENT_TYPE TABLE.

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