全部答案

2017-07-26 17:52:36

•   Oracle数据字典     以下表格中收集了Oracle数据字典中几乎所有的视图或别名，至于每个视图或别名的字段请用‘Describe’语句来查询。 命名说明：     Oracle数据字典中，对象名称多数以"USER。"，"ALL。"，"DBA。
    "为前缀"USER。"视图中记录通常记录执行查询的帐户所拥有的对象的信息，"ALL。"视图中记录包括"USER"记录和授权至PUBLIC或用户的对象的信息，"DBA。"视图包含所有数据库对象，而不管其所有者。
     　　使用举例： 　　select * from dba_data_files     查询表空间的信息(当前用户必须拥有DBA角色) 　　select owner , object_name ,object_type from all_objects     查询某一用户下的所有表、过程、函数等信息 　　视图名                                 描述   　　ALL_CATALOG               All tables, views, synonyms, sequences accessible to the user   　　ALL_COL_COMMENTS          Comments on columns of accessible tables and views   　　ALL_COL_GRANTS_MADE       Grants on columns for which the user is owner or grantor  　　ALL_COL_GRANTS_RECD      Grants on columns for which the user or PUBLIC is the grantee   　　ALL_COL_PRIVS            Grants on columns for which the user is the grantor, grantee, owner, or an                          enabled role or PUBLIC is the grantee   　　ALL_COL_PRIVS_MADE       Grants on columns for which the user is owner or grantor  　　ALL_COL_PRIVS_RECD       Grants on columns for which the user, PUBLIC or enabled role is the grantee   　　ALL_CONSTRAINTS          Constraint definitions on accessible tables   　　ALL_CONS_COLUMNS         Information about accessible columns in constraint definitions   　　ALL_DB_LINKS              Database links accessible to the user   　　ALL_DEF_AUDIT_OPTS         Auditing options for newly created objects   　　ALL_DEPENDENCIES          Dependencies to and from objects accessible to the user   　　ALL_ERRORS                  Current errors on stored objects that user is allowed to create   　　ALL_INDEXES            Descriptions of indexes on tables accessible to the user   　　ALL_IND_COLUMNS        COLUMNs comprising INDEXes on accessible TABLES   　　ALL_OBJECTS          Objects accessible to the user   　　ALL_REFRESH             All the refresh groups that the user can touch   　　ALL_REFRESH_CHILDREN   All the objects in refresh groups, where the user can touch the group   　　ALL_SEQUENCES                   Description of SEQUENCEs accessible to the user   　　ALL_SNAPSHOTS           Snapshots the user can look at   　　ALL_SOURCE              Current source on stored objects that user is allowed to create   　　ALL_SYNONYMS           All synonyms accessible to the user   　　ALL_TABLES         Description of tables accessible to the user   　　ALL_TAB_COLUMNS         Columns of all tables, views and clusters   　　ALL_TAB_COMMENTS         Comments on tables and views accessible to the user   　　ALL_TAB_GRANTS_MADE         User's grants and grants on user's objects   　　ALL_TAB_GRANTS_RECD         Grants on objects for which the user or PUBLIC is the grantee   　　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_TRIGGERS         Triggers accessible to the current user   　　ALL_TRIGGER_COLS          Column usage in user's triggers or in triggers on user's tables   　　ALL_USERS            Information about all users of the database   　　ALL_VIEWS            Text of views accessible to the user   　　USER_AUDIT_CONNECT   Audit trail entries for user logons/logoffs   　　USER_AUDIT_OBJECT    Audit trail records for statements concerning objects, specifically: table,                        cluster, view, index, sequence, [public] database link, [public] synonym,                       procedure, trigger, rollback segment, tablespace, role, user  
  完成  丢弃。

  全部
  

  笑***

  2017-07-26 17:52:36

  44 2 评论

  分享
  提交评论