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 |
数据字典中相关object的名称和描述!
最新推荐文章于 2024-01-10 08:14:45 发布