|
视图名
|
描述
|
| 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 |
| USER_AUDIT_SESSION |
|
| USER_AUDIT_STATEMENT |
Audit
trail records concerning grant, revoke, audit, noaudit and alter system
|
| USER_AUDIT_TRAIL |
Audit
trail entries relevant to the user |
| USER_CATALOG |
Tables,
Views, Synonyms and Sequences owned by the user |
| USER_CLUSTERS |
Descriptions
of user's own clusters |
| USER_CLU_COLUMNS |
Mapping
of table columns to cluster columns |
| USER_COL_COMMENTS |
Comments
on columns of user's tables and views |
| USER_COL_GRANTS |
Grants
on columns for which the user is the owner, grantor or grantee |
| USER_COL_GRANTS_MADE |
All
grants on columns of objects owned by the user |
| USER_COL_GRANTS_RECD |
Grants
on columns for which the user is the grantee |
| USER_COL_PRIVS |
Grants
on columns for which the user is the owner, grantor or grantee |
| USER_COL_PRIVS_MADE |
All
grants on columns of objects owned by the user |
| USER_COL_PRIVS_RECD |
Grants
on columns for which the user is the grantee |
| USER_CONSTRAINTS |
Constraint
definitions on user's own tables |
| USER_CONS_COLUMNS |
Information
about accessible columns in constraint definitions |
| USER_CROSS_REFS |
Cross
references for user's views and synonyms |
| USER_DB_LINKS |
Database
links owned by the user |
| USER_DEPENDENCIES |
Dependencies
to and from a users objects |
| USER_ERRORS |
Current
errors on stored objects owned by the user |
| USER_EXTENTS |
Extents
comprising segments owned by the user |
| USER_FREE_SPACE |
Free
extents in tablespaces accessible to the user |
| USER_INDEXES |
Description
of the user's own indexes |
| USER_IND_COLUMNS |
COLUMNs
comprising user's INDEXes or on user's TABLES |
| USER_JOBS |
All
jobs owned by this user |
| USER_OBJECTS |
Objects
owned by the user |
| USER_OBJECT_SIZE |
Sizes,
in bytes, of various pl/sql objects |
| USER_OBJ_AUDIT_OPTS |
Auditing
options for user's own tables and views |
| USER_REFRESH |
All
the refresh groups |
| USER_REFRESH_CHILDREN |
All
the objects in refresh groups, where the user owns the refresh group
|
| USER_RESOURCE_LIMITS |
Display
resource limit of the user |
| USER_ROLE_PRIVS |
Roles
granted to current user |
| USER_SEGMENTS |
Storage
allocated for all database segments |
| USER_SEQUENCES |
Description
of the user's own SEQUENCEs |
| USER_SNAPSHOTS |
Snapshots
the user can look at |
| USER_SNAPSHOT_LOGS |
All
snapshot logs owned by the user |
| USER_SOURCE |
Source
of stored objects accessible to the user |
| USER_SYNONYMS |
The
user's private synonyms |
| USER_SYS_PRIVS |
System
privileges granted to current user |
| USER_TABLES |
Description
of the user's own tables |
| USER_TABLESPACES |
Description
of accessible tablespaces |
| USER_TAB_AUDIT_OPTS |
Auditing
options for user's own tables and views |
| USER_TAB_COLUMNS |
Columns
of user's tables, views and clusters |
| USER_TAB_COMMENTS |
Comments
on the tables and views owned by the user |
| USER_TAB_GRANTS |
Grants
on objects for which the user is the owner, grantor or grantee |
| USER_TAB_GRANTS_MADE |
All
grants on objects owned by the user |
| USER_TAB_GRANTS_RECD |
Grants
on objects for which the user is the grantee |
| USER_TAB_PRIVS |
Grants
on objects for which the user is the owner, grantor or grantee |
| USER_TAB_PRIVS_MADE |
All
grants on objects owned by the user |
| USER_TAB_PRIVS_RECD |
Grants
on objects for which the user is the grantee |
| USER_TRIGGERS |
Triggers
owned by the user |
| USER_TRIGGER_COLS |
Column
usage in user's triggers |
| USER_TS_QUOTAS |
Tablespace
quotas for the user |
| USER_USERS |
Information
about the current user |
| USER_VIEWS |
Text
of views owned by the user |
| AUDIT_ACTIONS |
Description
table for audit trail action type codes. Maps action type numbers
to action type names |
| COLUMN_PRIVILEGES |
Grants
on columns for which the user is the grantor, grantee, owner, or an
enabled role or PUBLIC is the grantee |
| DICTIONARY |
Description
of data dictionary tables and views |
| DICT_COLUMNS |
Description
of columns in data dictionary tables and views |
| DUAL |
|
| GLOBAL_NAME |
global
database name |
| INDEX_HISTOGRAM |
statistics
on keys with repeat count |
| INDEX_STATS |
statistics
on the b-tree |
| RESOURCE_COST |
Cost
for each resource |
| ROLE_ROLE_PRIVS |
Roles
which are granted to roles |
| ROLE_SYS_PRIVS |
System
privileges granted to roles |
| 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. |
| TABLE_PRIVILEGES |
Grants
on objects for which the user is the grantor, grantee, owner, or an
enabled role or PUBLIC is the grantee |
| ACCESSIBLE_COLUMNS |
Synonym
for ALL_TAB_COLUMNS |
| ALL_COL_GRANTS |
Synonym
for COLUMN_PRIVILEGES |
| ALL_JOBS |
Synonym
for USER_JOBS |
| ALL_TAB_GRANTS |
Synonym
for TABLE_PRIVILEGES |
| CAT |
Synonym
for USER_CATALOG |
| CLU
|
Synonym
for USER_CLUSTERS |
| COLS |
Synonym
for USER_TAB_COLUMNS |
| DBA_AUDIT_CONNECT
|
Synonym
for USER_AUDIT_CONNECT |
| DBA_AUDIT_RESOURCE |
Synonym
for USER_AUDIT_RESOURCE |
| DBA_REFRESH_CHILDREN |
Synonym
for USER_REFRESH_CHILDREN |
| DICT |
Synonym
for DICTIONARY |
| IND |
Synonym
for USER_INDEXES |
| OBJ |
Synonym
for USER_OBJECTS |
| SEQ |
Synonym
for USER_SEQUENCES |
| SM$VERSION |
Synonym
for SM_$VERSION |
| SYN |
Synonym
for USER_SYNONYMS |
| TABS |
Synonym
for USER_TABLES |
| V$ACCESS |
Synonym
for V_$ACCESS |
| V$ARCHIVE |
Synonym
for V_$ARCHIVE |
| V$BACKUP |
Synonym
for V_$BACKUP |
| V$BGPROCESS |
Synonym
for V_$BGPROCESS |
| V$CIRCUIT |
Synonym
for V_$CIRCUIT |
| V$COMPATIBILITY |
Synonym
for V_$COMPATIBILITY |
| V$COMPATSEG |
Synonym
for V_$COMPATSEG |
| V$CONTROLFILE |
Synonym
for V_$CONTROLFILE |
| V$DATABASE |
Synonym
for V_$DATABASE |
| V$DATAFILE |
Synonym
for V_$DATAFILE |
| V$DBFILE |
Synonym
for V_$DBFILE |
| V$DBLINK |
Synonym
for V_$DBLINK |
| V$DB_OBJECT_CACHE |
Synonym
for V_$DB_OBJECT_CACHE |
| V$DISPATCHER |
Synonym
for V_$DISPATCHER |
| V$ENABLEDPRIVS |
Synonym
for V_$ENABLEDPRIVS |
| V$FILESTAT |
Synonym
for V_$FILESTAT |
| V$FIXED_TABLE |
Synonym
for V_$FIXED_TABLE |
| V$LATCH |
Synonym
for V_$LATCH |
| V$LATCHHOLDER |
Synonym
for V_$LATCHHOLDER |
| V$LATCHNAME |
Synonym
for V_$LATCHNAME |
| V$LIBRARYCACHE |
Synonym
for V_$LIBRARYCACHE |
| V$LICENSE |
Synonym
for V_$LICENSE |
| V$LOADCSTAT |
Synonym
for V_$LOADCSTAT |
| V$LOADTSTAT |
Synonym
for V_$LOADTSTAT |
| V$LOCK |
Synonym
for V_$LOCK |
| V$LOG |
Synonym
for V_$LOG |
| V$LOGFILE |
Synonym
for V_$LOGFILE |
| V$LOGHIST |
Synonym
for V_$LOGHIST |
| V$LOG_HISTORY |
Synonym
for V_$LOG_HISTORY |
| V$MLS_PARAMETERS |
Synonym
for V_$MLS_PARAMETERS |
| V$MTS |
Synonym
for V_$MTS |
| V$NLS_PARAMETERS
|
Synonym
for V_$NLS_PARAMETERS |
| V$NLS_VALID_VALUES |
Synonym
for V_$NLS_VALID_VALUES |
| V$OPEN_CURSOR
|
Synonym
for V_$OPEN_CURSOR |
| V$OPTION
|
Synonym
for V_$OPTION |
| V$PARAMETER
|
Synonym
for V_$PARAMETER |
| V$PQ_SESSTAT
|
Synonym
for V_$PQ_SESSTAT |
| V$PQ_SLAVE
|
Synonym
for V_$PQ_SLAVE |
| V$PQ_SYSSTAT |
Synonym
for V_$PQ_SYSSTAT |
| V$PROCESS |
Synonym
for V_$PROCESS |
| V$QUEUE |
Synonym
for V_$QUEUE |
| V$RECOVERY_LOG |
Synonym
for V_$RECOVERY_LOG |
| V$RECOVER_FILE |
Synonym
for V_$RECOVER_FILE |
| V$REQDIST |
Synonym
for V_$REQDIST |
| V$RESOURCE |
Synonym
for V_$RESOURCE |
| V$ROLLNAME |
Synonym
for V_$ROLLNAME |
| V$ROLLSTAT |
Synonym
for V_$ROLLSTAT |
| V$ROWCACHE |
Synonym
for V_$ROWCACHE |
| V$SESSION |
Synonym
for V_$SESSION |
| V$SESSION_CURSOR_CACHE |
Synonym
for V_$SESSION_CURSOR_CACHE |
| V$SESSION_EVENT |
Synonym
for V_$SESSION_EVENT |
| V$SESSION_WAIT |
Synonym
for V_$SESSION_WAIT |
| V$SESSTAT |
Synonym
for V_$SESSTAT |
| V$SESS_IO |
Synonym
for V_$SESS_IO |
| V$SGA |
Synonym
for V_$SGA |
| V$SGASTAT |
Synonym
for V_$SGASTAT |
| V$SHARED_SERVER |
Synonym
for V_$SHARED_SERVER |
| V$SQLAREA |
Synonym
for V_$SQLAREA |
| V$STATNAME |
Synonym
for V_$STATNAME |
| V$SYSSTAT |
Synonym
for V_$SYSSTAT |
| V$SYSTEM_CURSOR_CACHE |
Synonym
for V_$SYSTEM_CURSOR_CACHE |
| V$SYSTEM_EVENT |
Synonym
for V_$SYSTEM_EVENT |
| V$THREAD |
Synonym
for V_$THREAD |
| V$TIMER |
Synonym
for V_$TIMER |
| V$TRANSACTION |
Synonym
for V_$TRANSACTION |
| V$TYPE_SIZE |
Synonym
for V_$TYPE_SIZE |
| V$VERSION |
Synonym
for V_$VERSION |
| V$WAITSTAT |
Synonym
for V_$WAITSTAT |
| V$_LOCK |
Synonym
for V_$_LOCK |