视图名
|
描述
|
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
|