数据字典中相关object的名称和描述!

ALL_ALL_TABLESDescription of all object and relational tables accessible to the user
ALL_BASE_TABLE_MVIEWSAll materialized views with log(s) in the database that the user can see
ALL_CAPTURE_PREPARED_DATABASEIs the local database prepared for instantiation?
ALL_CAPTURE_PREPARED_TABLESAll tables visible to the current user that are prepared for instantiation
ALL_EVALUATION_CONTEXT_TABLEStables in all rule evaluation contexts seen by the user
ALL_EXTERNAL_TABLESDescription of the external tables accessible to the user
ALL_NESTED_TABLESDescription of nested tables in tables accessible to the user
ALL_OBJECT_TABLESDescription of all object tables accessible to the user
ALL_PARTIAL_DROP_TABSAll tables with patially dropped columns accessible to the user
ALL_PART_TABLES 
ALL_PENDING_CONV_TABLESAll tables accessible to the user which are not upgraded to the latest type version
ALL_QUEUE_TABLESAll queue tables accessible to the user
ALL_SOURCE_TABLES 
ALL_SOURCE_TAB_COLUMNS 
ALL_STREAMS_TABLE_RULESRules created by streams administrative APIs on tables visible to the current user
ALL_SUBSCRIBED_TABLES 
ALL_TABLESDescription of relational tables accessible to the user
ALL_TAB_COLSColumns of user's tables, views and clusters
ALL_TAB_COLUMNSColumns of user's tables, views and clusters
ALL_TAB_COL_STATISTICSColumns of user's tables, views and clusters
ALL_TAB_COMMENTSComments on tables and views accessible to the user
ALL_TAB_HISTOGRAMSHistograms on columns of all tables visible to user
ALL_TAB_MODIFICATIONSInformation regarding modifications to tables
ALL_TAB_PARTITIONS 
ALL_TAB_PRIVSGrants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
ALL_TAB_PRIVS_MADEUser's grants and grants on user's objects
ALL_TAB_PRIVS_RECDGrants on objects for which the user, PUBLIC or enabled role is the grantee
ALL_TAB_SUBPARTITIONS 
ALL_UNUSED_COL_TABSAll tables with unused columns accessible to the user
ALL_UPDATABLE_COLUMNSDescription of all updatable columns
ALL_XML_TABLESDescription of the all XMLType tables that the user has privileges on
ALL_XML_TAB_COLSDescription of the all XMLType tables that the user has privileges on
DBA_ALL_TABLESDescription of all object and relational tables in the database
DBA_BASE_TABLE_MVIEWSAll materialized views with log(s) in the database
DBA_CACHEABLE_NONTABLE_OBJECTS 
DBA_CACHEABLE_TABLES 
DBA_CACHEABLE_TABLES_BASE 
DBA_CAPTURE_PREPARED_DATABASEIs the local database prepared for instantiation?
DBA_CAPTURE_PREPARED_TABLESAll tables prepared for instantiation
DBA_EVALUATION_CONTEXT_TABLEStables in all rule evaluation contexts in the database
DBA_EXTERNAL_TABLESDescription of the external tables accessible to the DBA
DBA_NESTED_TABLESDescription of nested tables contained in all tables
DBA_OBJECT_TABLESDescription of all object tables in the database
DBA_PARTIAL_DROP_TABSAll tables with partially dropped columns in the database
DBA_PART_TABLES 
DBA_PENDING_CONV_TABLESAll tables which are not upgraded to the latest type version in the database
DBA_QUEUE_TABLESAll queue tables created in the database
DBA_SOURCE_TABLES 
DBA_SOURCE_TAB_COLUMNS 
DBA_STREAMS_TABLE_RULESTable rules created by streams administrative APIs
DBA_SUBSCRIBED_TABLES 
DBA_TABLESDescription of all relational tables in the database
DBA_TABLESPACESDescription of all tablespaces
DBA_TAB_COLSColumns of user's tables, views and clusters
DBA_TAB_COLUMNSColumns of user's tables, views and clusters
DBA_TAB_COL_STATISTICSColumns of user's tables, views and clusters
DBA_TAB_COMMENTSComments on all tables and views in the database
DBA_TAB_HISTOGRAMSHistograms on columns of all tables
DBA_TAB_MODIFICATIONSInformation regarding modifications to tables
DBA_TAB_PARTITIONS 
DBA_TAB_PRIVSAll grants on objects in the database
DBA_TAB_SUBPARTITIONS 
DBA_UNUSED_COL_TABSAll tables with unused columns in the database
DBA_UPDATABLE_COLUMNSDescription of dba updatable columns
DBA_XML_TABLESDescription of all XML tables in the database
DBA_XML_TAB_COLSDescription of all XML tables in the database
USER_ALL_TABLESDescription of all object and relational tables owned by the user's
USER_BASE_TABLE_MVIEWSAll materialized views with log(s) owned by the user in the database
USER_EVALUATION_CONTEXT_TABLEStables in user rule evaluation contexts
USER_EXTERNAL_TABLESDescription of the user's own external tables
USER_NESTED_TABLESDescription of nested tables contained in the user's own tables
USER_OBJECT_TABLESDescription of the user's own object tables
USER_PARTIAL_DROP_TABSUser tables with unused columns
USER_PART_TABLES 
USER_PENDING_CONV_TABLESAll user's tables which are not upgraded to the latest type version
USER_QUEUE_TABLESAll queue tables created by the user
USER_SOURCE_TABLES 
USER_SOURCE_TAB_COLUMNS 
USER_SUBSCRIBED_TABLES 
USER_TABLESDescription of the user's own relational tables
USER_TABLESPACESDescription of accessible tablespaces
USER_TAB_COLSColumns of user's tables, views and clusters
USER_TAB_COLUMNSColumns of user's tables, views and clusters
USER_TAB_COL_STATISTICSColumns of user's tables, views and clusters
USER_TAB_COMMENTSComments on the tables and views owned by the user
USER_TAB_HISTOGRAMSHistograms on columns of user's tables
USER_TAB_MODIFICATIONSInformation regarding modifications to tables
USER_TAB_PARTITIONS 
USER_TAB_PRIVSGrants on objects for which the user is the owner, grantor or grantee
USER_TAB_PRIVS_MADEAll grants on objects owned by the user
USER_TAB_PRIVS_RECDGrants on objects for which the user is the grantee
USER_TAB_SUBPARTITIONS 
USER_UNUSED_COL_TABSUser tables with unused columns
USER_UPDATABLE_COLUMNSDescription of updatable columns
USER_XML_TABLESDescription of the user's own XMLType tables
USER_XML_TAB_COLSDescription of the user's own XMLType tables
DATABASE_COMPATIBLE_LEVELDatabase compatible parameter set via init.ora
NLS_DATABASE_PARAMETERSPermanent NLS parameters of the database
ROLE_TAB_PRIVSTable privileges granted to roles
TABLE_PRIVILEGESGrants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
GV$DATABASESynonym for GV_$DATABASE
GV$DATABASE_BLOCK_CORRUPTIONSynonym for GV_$DATABASE_BLOCK_CORRUPTION
GV$DATABASE_INCARNATIONSynonym for GV_$DATABASE_INCARNATION
GV$FIXED_TABLESynonym for GV_$FIXED_TABLE
GV$TABLESPACESynonym for GV_$TABLESPACE
TABSSynonym for USER_TABLES
V$DATABASESynonym for V_$DATABASE
V$DATABASE_BLOCK_CORRUPTIONSynonym for V_$DATABASE_BLOCK_CORRUPTION
V$DATABASE_INCARNATIONSynonym for V_$DATABASE_INCARNATION
V$FIXED_TABLESynonym for V_$FIXED_TABLE
V$TABLESPACESynonym for V_$TABLESPACE
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值