Table missing in dba_tables but visible in dba_segments & dba_objects
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.