Oracle 系统表

Below is an alphabetical listing of the Oracle system tables that are commonly used.

System Table

Description

ALL_ARGUMENTS

Arguments in object accessible to the user

ALL_CATALOG

All tables, views, synonyms, sequences accessible to the user

ALL_COL_COMMENTS

Comments on columns of accessible tables and views

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_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_LOBS

Description of LOBs contained in tables accessible to the user

ALL_OBJECTS

Objects accessible to the user

ALL_OBJECT_TABLES

Description of all object tables accessible to the user

ALL_SEQUENCES

Description of SEQUENCEs accessible to the user

ALL_SNAPSHOTS

Snapshots the user can access

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 relational tables accessible to the user

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_TRIGGERS

Triggers accessible to the current user

ALL_TRIGGER_COLS

Column usage in user's triggers or in triggers on user's tables

ALL_TYPES

Description of types accessible to the user

ALL_UPDATABLE_COLUMNS

Description of all updatable columns

ALL_USERS

Information about all users of the database

ALL_VIEWS

Description of views accessible to the user

DATABASE_COMPATIBLE_LEVEL

Database compatible parameter set via init.ora

DBA_DB_LINKS

All database links in the database

DBA_ERRORS

Current errors on all stored objects in the database

DBA_OBJECTS

All objects in the database

DBA_ROLES

All Roles which exist in the database

DBA_ROLE_PRIVS

Roles granted to users and roles

DBA_SOURCE

Source of all stored objects in the database

DBA_TABLESPACES

Description of all tablespaces

DBA_TAB_PRIVS

All grants on objects in the database

DBA_TRIGGERS

All triggers in the database

DBA_TS_QUOTAS

Tablespace quotas for all users

DBA_USERS

Information about all users of the database

DBA_VIEWS

Description of all views in the database

DICTIONARY

Description of data dictionary tables and views

DICT_COLUMNS

Description of columns in data dictionary tables and views

GLOBAL_NAME

global database name

NLS_DATABASE_PARAMETERS

Permanent NLS parameters of the database

NLS_INSTANCE_PARAMETERS

NLS parameters of the instance

NLS_SESSION_PARAMETERS

NLS parameters of the user session

PRODUCT_COMPONENT_VERSION

version and status information for component products

ROLE_TAB_PRIVS

Table privileges granted to roles

SESSION_PRIVS

Privileges which the user currently has set

SESSION_ROLES

Roles which the user currently has enabled.

SYSTEM_PRIVILEGE_MAP

Description table for privilege type codes. Maps privilege type numbers to type names

TABLE_PRIVILEGES

Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee

TABLE_PRIVILEGE_MAP

Description table for privilege (auditing option) type codes. Maps privilege (auditing option) type numbers to type names

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

发表于

我来说两句

0 条评论
登录 后参与评论

相关文章

来自专栏Greenplum

Greenplum gpload命令使用

Runs a load job as defined in a YAML formatted control file.

3461
来自专栏ASP.NET MVC5 后台权限管理系统

ASP.NET MVC5+EF6+EasyUI 后台管理系统(35)-文章发布系统②-构建项目

注:阅读本文,需要阅读本系列的之前文章 代码生成器下载地址(文章开头处)  接下来我们建立数据库的表和各层的代码 我们只需要两张表,文章列表(MIS_Artic...

2399
来自专栏杨建荣的学习笔记

linux下安装mysql的问题解决

最近试了下在Linux下安装mysql,我只选了server和client两个组件,没有装其他的组件. 安装包的下载可以参见 http://www.mysql....

3986
来自专栏ASP.NET MVC5 后台权限管理系统

ASP.NET MVC5+EF6+EasyUI 后台管理系统(42)-工作流设计-表建立

工作流在实际应用中还是比较广泛,网络中存在很多工作流的图形化插件,可以做到拉拽的工作流设计,非常简便,再配合第三方编辑器,可以直接生成表单,我没有刻意的浏览很多...

20110
来自专栏SAP最佳业务实践

SAP S/4 HANA新变化-FI数据模型

With the installation of SAP Simple Finance, on-premise edition totals and appli...

4307
来自专栏三木的博客

顺序存储线性表的实现

最近复习数据结构,写了一个顺序存储的线性表,代码粘在这里:) 代码下载:git@github.com:Wang-Sen/algorithm.git /* * ...

2136
来自专栏一个会写诗的程序员的博客

图解 SQL join 语句内联合(inner join)全外联合(full outer join)左外联合(left outer join)笛卡尔积 (交叉联合(cross join))

我们用过name字段用几种不同方式把这些表联合起来,看能否得到和那些漂亮的韦恩图在概念上的匹配。

922
来自专栏乐沙弥的世界

SQL,PL/SQL 数据类型一览表

The following is a list of datatypes available in Oracle.

1093
来自专栏数据处理

CEdit只能输入16进制数

1375
来自专栏一个会写诗的程序员的博客

JPA 执行update/delete query 需要加上事务

Caused by: org.springframework.dao.InvalidDataAccessApiUsageException: Executing...

1172

扫码关注云+社区

领取腾讯云代金券