| 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 |
Tablas de sistema
