Share this page:

oracle tutorial

Oracle/PLSQL: Oracle System Tables

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

System Table
ALL_ARGUMENTS
ALL_CATALOG
ALL_COL_COMMENTS
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
ALL_DB_LINKS
ALL_ERRORS
ALL_INDEXES
ALL_IND_COLUMNS
ALL_LOBS
ALL_OBJECTS
ALL_OBJECT_TABLES
ALL_SEQUENCES
ALL_SNAPSHOTS
ALL_SOURCE
ALL_SYNONYMS
ALL_TABLES
ALL_TAB_COLUMNS
ALL_TAB_COL_STATISTICS
ALL_TAB_COMMENTS
ALL_TRIGGERS
ALL_TRIGGER_COLS
ALL_TYPES
ALL_UPDATABLE_COLUMNS
ALL_USERS
ALL_VIEWS
DATABASE_COMPATIBLE_LEVEL
DBA_DB_LINKS
DBA_ERRORS
DBA_OBJECTS
DBA_ROLES
DBA_ROLE_PRIVS
DBA_SOURCE
DBA_TABLESPACES
DBA_TAB_PRIVS
DBA_TRIGGERS
DBA_TS_QUOTAS
DBA_USERS
DBA_VIEWS
DICTIONARY
DICT_COLUMNS
GLOBAL_NAME
NLS_DATABASE_PARAMETERS
NLS_INSTANCE_PARAMETERS
NLS_SESSION_PARAMETERS
PRODUCT_COMPONENT_VERSION
ROLE_TAB_PRIVS
SESSION_PRIVS
SESSION_ROLES
SYSTEM_PRIVILEGE_MAP
TABLE_PRIVILEGES
TABLE_PRIVILEGE_MAP