ALL_ALL_TABLES |
Description of all object and relational tables accessible to the user |
ALL_BASE_TABLE_MVIEWS |
All materialized views with log(s) in the database that the user can see |
ALL_CAPTURE_PREPARED_DATABASE |
Is the local database prepared for instantiation? |
ALL_CAPTURE_PREPARED_TABLES |
All tables visible to the current user that are prepared for instantiation |
ALL_EVALUATION_CONTEXT_TABLES |
tables in all rule evaluation contexts seen by the user |
ALL_EXTERNAL_TABLES |
Description of the external tables accessible to the user |
ALL_NESTED_TABLES |
Description of nested tables in tables accessible to the user |
ALL_OBJECT_TABLES |
Description of all object tables accessible to the user |
ALL_PARTIAL_DROP_TABS |
All tables with patially dropped columns accessible to the user |
ALL_PART_TABLES |
|
ALL_PENDING_CONV_TABLES |
All tables accessible to the user which are not upgraded to the latest type version |
ALL_QUEUE_TABLES |
All queue tables accessible to the user |
ALL_SOURCE_TABLES |
|
ALL_SOURCE_TAB_COLUMNS |
|
ALL_STREAMS_TABLE_RULES |
Rules created by streams administrative APIs on tables visible to the current user |
ALL_SUBSCRIBED_TABLES |
|
ALL_TABLES |
Description of relational tables accessible to the user |
ALL_TAB_COLS |
Columns of user's tables, views and clusters |
ALL_TAB_COLUMNS |
Columns of user's tables, views and clusters |
ALL_TAB_COL_STATISTICS |
Columns of user's tables, views and clusters |
ALL_TAB_COMMENTS |
Comments on tables and views accessible to the user |
ALL_TAB_HISTOGRAMS |
Histograms on columns of all tables visible to user |
ALL_TAB_MODIFICATIONS |
Information regarding modifications to tables |
ALL_TAB_PARTITIONS |
|
ALL_TAB_PRIVS |
Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee |
ALL_TAB_PRIVS_MADE |
User's grants and grants on user's objects |
ALL_TAB_PRIVS_RECD |
Grants on objects for which the user, PUBLIC or enabled role is the grantee |
ALL_TAB_SUBPARTITIONS |
|
ALL_UNUSED_COL_TABS |
All tables with unused columns accessible to the user |
ALL_UPDATABLE_COLUMNS |
Description of all updatable columns |
ALL_XML_TABLES |
Description of the all XMLType tables that the user has privileges on |
ALL_XML_TAB_COLS |
Description of the all XMLType tables that the user has privileges on |
DBA_ALL_TABLES |
Description of all object and relational tables in the database |
DBA_BASE_TABLE_MVIEWS |
All materialized views with log(s) in the database |
DBA_CACHEABLE_NONTABLE_OBJECTS |
|
DBA_CACHEABLE_TABLES |
|
DBA_CACHEABLE_TABLES_BASE |
|
DBA_CAPTURE_PREPARED_DATABASE |
Is the local database prepared for instantiation? |
DBA_CAPTURE_PREPARED_TABLES |
All tables prepared for instantiation |
DBA_EVALUATION_CONTEXT_TABLES |
tables in all rule evaluation contexts in the database |
DBA_EXTERNAL_TABLES |
Description of the external tables accessible to the DBA |
DBA_NESTED_TABLES |
Description of nested tables contained in all tables |
DBA_OBJECT_TABLES |
Description of all object tables in the database |
DBA_PARTIAL_DROP_TABS |
All tables with partially dropped columns in the database |
DBA_PART_TABLES |
|
DBA_PENDING_CONV_TABLES |
All tables which are not upgraded to the latest type version in the database |
DBA_QUEUE_TABLES |
All queue tables created in the database |
DBA_SOURCE_TABLES |
|
DBA_SOURCE_TAB_COLUMNS |
|
DBA_STREAMS_TABLE_RULES |
Table rules created by streams administrative APIs |
DBA_SUBSCRIBED_TABLES |
|
DBA_TABLES |
Description of all relational tables in the database |
DBA_TABLESPACES |
Description of all tablespaces |
DBA_TAB_COLS |
Columns of user's tables, views and clusters |
DBA_TAB_COLUMNS |
Columns of user's tables, views and clusters |
DBA_TAB_COL_STATISTICS |
Columns of user's tables, views and clusters |
DBA_TAB_COMMENTS |
Comments on all tables and views in the database |
DBA_TAB_HISTOGRAMS |
Histograms on columns of all tables |
DBA_TAB_MODIFICATIONS |
Information regarding modifications to tables |
DBA_TAB_PARTITIONS |
|
DBA_TAB_PRIVS |
All grants on objects in the database |
DBA_TAB_SUBPARTITIONS |
|
DBA_UNUSED_COL_TABS |
All tables with unused columns in the database |
DBA_UPDATABLE_COLUMNS |
Description of dba updatable columns |
DBA_XML_TABLES |
Description of all XML tables in the database |
DBA_XML_TAB_COLS |
Description of all XML tables in the database |
USER_ALL_TABLES |
Description of all object and relational tables owned by the user's |
USER_BASE_TABLE_MVIEWS |
All materialized views with log(s) owned by the user in the database |
USER_EVALUATION_CONTEXT_TABLES |
tables in user rule evaluation contexts |
USER_EXTERNAL_TABLES |
Description of the user's own external tables |
USER_NESTED_TABLES |
Description of nested tables contained in the user's own tables |
USER_OBJECT_TABLES |
Description of the user's own object tables |
USER_PARTIAL_DROP_TABS |
User tables with unused columns |
USER_PART_TABLES |
|
USER_PENDING_CONV_TABLES |
All user's tables which are not upgraded to the latest type version |
USER_QUEUE_TABLES |
All queue tables created by the user |
USER_SOURCE_TABLES |
|
USER_SOURCE_TAB_COLUMNS |
|
USER_SUBSCRIBED_TABLES |
|
USER_TABLES |
Description of the user's own relational tables |
USER_TABLESPACES |
Description of accessible tablespaces |
USER_TAB_COLS |
Columns of user's tables, views and clusters |
USER_TAB_COLUMNS |
Columns of user's tables, views and clusters |
USER_TAB_COL_STATISTICS |
Columns of user's tables, views and clusters |
USER_TAB_COMMENTS |
Comments on the tables and views owned by the user |
USER_TAB_HISTOGRAMS |
Histograms on columns of user's tables |
USER_TAB_MODIFICATIONS |
Information regarding modifications to tables |
USER_TAB_PARTITIONS |
|
USER_TAB_PRIVS |
Grants on objects for which the user is the owner, grantor or grantee |
USER_TAB_PRIVS_MADE |
All grants on objects owned by the user |
USER_TAB_PRIVS_RECD |
Grants on objects for which the user is the grantee |
USER_TAB_SUBPARTITIONS |
|
USER_UNUSED_COL_TABS |
User tables with unused columns |
USER_UPDATABLE_COLUMNS |
Description of updatable columns |
USER_XML_TABLES |
Description of the user's own XMLType tables |
USER_XML_TAB_COLS |
Description of the user's own XMLType tables |
DATABASE_COMPATIBLE_LEVEL |
Database compatible parameter set via init.ora |
NLS_DATABASE_PARAMETERS |
Permanent NLS parameters of the database |
ROLE_TAB_PRIVS |
Table privileges granted to roles |
TABLE_PRIVILEGES |
Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee |
GV$DATABASE |
Synonym for GV_$DATABASE |
GV$DATABASE_BLOCK_CORRUPTION |
Synonym for GV_$DATABASE_BLOCK_CORRUPTION |
GV$DATABASE_INCARNATION |
Synonym for GV_$DATABASE_INCARNATION |
GV$FIXED_TABLE |
Synonym for GV_$FIXED_TABLE |
GV$TABLESPACE |
Synonym for GV_$TABLESPACE |
TABS |
Synonym for USER_TABLES |
V$DATABASE |
Synonym for V_$DATABASE |
V$DATABASE_BLOCK_CORRUPTION |
Synonym for V_$DATABASE_BLOCK_CORRUPTION |
V$DATABASE_INCARNATION |
Synonym for V_$DATABASE_INCARNATION |
V$FIXED_TABLE |
Synonym for V_$FIXED_TABLE |
V$TABLESPACE |
Synonym for V_$TABLESPACE |