欢迎来到我的地盘:今天是

若得山花插满头,莫问奴归处!

  博客园 :: 首页 :: 博问 :: 闪存 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理 ::
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
posted on 2007-10-18 10:05  莫问奴归处  阅读(583)  评论(0编辑  收藏  举报
轩轩娃