CODEWITHSUNDEEP
oracle-database
maseed ilyas
maseed ilyas

Reputation: 1

Table missing in dba_objects and dba_tab_columns

I have a oracle database where some tables which are present in dba_tables are not present in dba_objects and dba_tab_columns. Can anyone help me understand why there is mismatch between these three metadata tables ?

Upvotes: 0

Views: 471

Answers (1)

Sayan Malakshinov
Sayan Malakshinov

Reputation: 8655

If you mean SYS."default_auditing_options":

SQL> select owner,table_name from dba_tables
     minus 
     select owner,object_name from dba_objects where object_type='TABLE';

OWNER                          TABLE_NAME
------------------------------ ------------------------------
SYS                            _default_auditing_options_

That is an internal special oracle table, read this doc: Why Do DBA_TABLES DBA_OBJECTS And DBA_SEGMENTS Differ When Selected For Tables? (Doc ID 363048.1)

Upvotes: 1

Related Questions