I have 2 queries
SELECT * FROM sys.dba_indexes WHERE Table_Name = 'XDB$RESOURCE'
SELECT * FROM sys.dba_tables WHERE Table_Name = 'XDB$RESOURCE'
Are there any reasons why a table wouldn't show in
sys.dba_tables? As far as I've read all tables should show here, hence why I'm using this rather than
Can an index in Oracle be against a deleted table?
Does sys.dba_tables show data relevant to access you have, and if so is there any table that rather brings back nothing than half the data?
Relatively new to Oracle, any explanation or advice appreciated.