ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
AUD...
AUDIT_ACTIONS: Description table for audit trail action type
codes. Maps action type
numbers to action type names
iSelfSchooling-SQL> desc AUDIT_ACTIONS;
Name
Null? Type
----------------------------- -------- --------------------
ACTION
NOT NULL NUMBER
NAME
NOT NULL VARCHAR2(28)
CAT: Synonym for USER_CATALOG
iSelfSchooling-SQL> desc CAT;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLE_TYPE
VARCHAR2(11)
CLU: Synonym for USER_CLUSTERS
iSelfSchooling-SQL> desc CLU;
Name
Null? Type
----------------------------- -------- --------------------
CLUSTER_NAME
NOT NULL VARCHAR2(30)
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
PCT_FREE
NUMBER
PCT_USED
NUMBER
KEY_SIZE
NUMBER
INI_TRANS
NOT NULL NUMBER
MAX_TRANS
NOT NULL NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NOT NULL NUMBER
MAX_EXTENTS
NOT NULL NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
AVG_BLOCKS_PER_KEY
NUMBER
CLUSTER_TYPE
VARCHAR2(5)
FUNCTION
VARCHAR2(15)
HASHKEYS
NUMBER
DEGREE
VARCHAR2(10)
INSTANCES
VARCHAR2(10)
CACHE
VARCHAR2(5)
BUFFER_POOL
VARCHAR2(7)
SINGLE_TABLE
VARCHAR2(5)
DEPENDENCIES
VARCHAR2(8)
COLS: Synonym for USER_TAB_COLUMNS
iSelfSchooling-SQL> desc COLS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
DATA_TYPE
VARCHAR2(106)
DATA_TYPE_MOD
VARCHAR2(3)
DATA_TYPE_OWNER
VARCHAR2(30)
DATA_LENGTH
NOT NULL NUMBER
DATA_PRECISION
NUMBER
DATA_SCALE
NUMBER
NULLABLE
VARCHAR2(1)
COLUMN_ID
NUMBER
DEFAULT_LENGTH
NUMBER
DATA_DEFAULT
LONG
NUM_DISTINCT
NUMBER
LOW_VALUE
RAW(32)
HIGH_VALUE
RAW(32)
DENSITY
NUMBER
NUM_NULLS
NUMBER
NUM_BUCKETS
NUMBER
LAST_ANALYZED
DATE
SAMPLE_SIZE
NUMBER
CHARACTER_SET_NAME
VARCHAR2(44)
CHAR_COL_DECL_LENGTH
NUMBER
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
AVG_COL_LEN
NUMBER
CHAR_LENGTH
NUMBER
CHAR_USED
VARCHAR2(1)
V80_FMT_IMAGE
VARCHAR2(3)
DATA_UPGRADED
VARCHAR2(3)
HISTOGRAM
VARCHAR2(15)
COLUMN_PRIVILEGES: Grants on columns for which the user is the
grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
iSelfSchooling-SQL> desc COLUMN_PRIVILEGES;
Name
Null? Type
----------------------------- -------- --------------------
GRANTEE
NOT NULL VARCHAR2(30)
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
GRANTOR
NOT NULL VARCHAR2(30)
INSERT_PRIV
VARCHAR2(1)
UPDATE_PRIV
VARCHAR2(1)
REFERENCES_PRIV
VARCHAR2(1)
CREATED
VARCHAR2
DATABASE_COMPATIBLE_LEVEL: Database compatible parameter set via init.ora
iSelfSchooling-SQL> desc DATABASE_COMPATIBLE_LEVEL;
Name
Null? Type
----------------------------- -------- --------------------
VALUE
VARCHAR2(512)
DESCRIPTION
VARCHAR2(255)
DBMS_ALERT_INFO
iSelfSchooling-SQL> desc DBMS_ALERT_INFO;
Name
Null? Type
----------------------------- -------- --------------------
NAME
NOT NULL VARCHAR2(30)
SID
NOT NULL VARCHAR2(30)
CHANGED
VARCHAR2(1)
MESSAGE
VARCHAR2(1800)
DBMS_LOCK_ALLOCATED
iSelfSchooling-SQL> desc DBMS_LOCK_ALLOCATED;
Name
Null? Type
----------------------------- -------- --------------------
NAME
NOT NULL VARCHAR2(128)
LOCKID
NUMBER(38)
EXPIRATION
DATE
DICT: Synonym for DICTIONARY
iSelfSchooling-SQL> desc DICT;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
COMMENTS VARCHAR2(4000)
DICTIONARY: Description of data dictionary tables and views
iSelfSchooling-SQL> desc DICTIONARY;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
DICT_COLUMNS: Description of columns in data dictionary tables
and views
iSelfSchooling-SQL> desc DICT_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
DTO$KCCDI: Synonym for DT_$KCCDI
iSelfSchooling-SQL> desc DTO$KCCDI;
Name
Null? Type
----------------------------- -------- --------------------
ADDR
RAW(8)
INDX
NUMBER
INST_ID
NUMBER
DIDFV
NUMBER
DIDFC
NUMBER
DICTS
VARCHAR2(20)
DIDBN
VARCHAR2(9)
DIRDB
NUMBER
DICCT
VARCHAR2(20)
DIFLG
NUMBER
DIIRS
VARCHAR2(16)
DIRLS
VARCHAR2(16)
DIRLC
VARCHAR2(20)
DIRLC_I
NUMBER
DIPRS
VARCHAR2(16)
DIPRC
VARCHAR2(20)
DIPRC_I
NUMBER
DIRDV
NUMBER
DIRDC
NUMBER
DINDF
NUMBER
DINTF
NUMBER
DINOF
NUMBER
DICPT
NUMBER
DISCN
VARCHAR2(16)
DINET
NUMBER
DINOT
NUMBER
DIOTH
NUMBER
DIOTT
NUMBER
DIETB
RAW(132)
DIMLM
NUMBER
DIMDM
NUMBER
DIARH
NUMBER
DIART
NUMBER
DIPRT
NUMBER
DIFAS
VARCHAR2(16)
DICKP_SCN
VARCHAR2(16)
DICKP_TIM
VARCHAR2(20)
DICSQ
NUMBER
DIDBI
NUMBER
DISSC_SCN
VARCHAR2(16)
DISSC_TIM
VARCHAR2(20)
DISFP
NUMBER
DIBSC
NUMBER
DIPOFB
NUMBER
DIPNFB
NUMBER
DICOFB
NUMBER
DICNFB
NUMBER
DIVTS
VARCHAR2(20)
DICID
NUMBER
DIDOR
NUMBER
DISLH
NUMBER
DISLT
NUMBER
DIRAE
NUMBER
DIACID
NUMBER
DIARS
VARCHAR2(16)
DISOS
NUMBER
DIDGD
NUMBER
DIMLA
NUMBER
DIPDB
NUMBER
DIFL2
NUMBER
DIPLID
NUMBER
DIPLN
VARCHAR2(101)
DICUR_SCN
VARCHAR2(16)
DIDBUN
VARCHAR2(30)
DIFSTS
NUMBER
DIFOPR
NUMBER
DIFTHS
NUMBER
DIFTGT
VARCHAR2(30)
DIFOBS
VARCHAR2(512)
DTO$KCVFH: Synonym for DT_$KCVFH
iSelfSchooling-SQL> desc DTO$KCVFH;
Name
Null? Type
----------------------------- -------- --------------------
ADDR
RAW(8)
INDX
NUMBER
INST_ID
NUMBER
HXFIL
NUMBER
HXONS
NUMBER
HXSTS
VARCHAR2(16)
HXERR
NUMBER
HXVER
NUMBER
FHSWV
NUMBER
FHCVN
NUMBER
FHDBI
NUMBER
FHDBN
VARCHAR2(9)
FHCSQ
NUMBER
FHFSZ
NUMBER
FHBSZ
NUMBER
FHFNO
NUMBER
FHTYP
NUMBER
FHRDB
NUMBER
FHCRS
VARCHAR2(16)
FHCRT
VARCHAR2(20)
FHRLC
VARCHAR2(20)
FHRLC_I
NUMBER
FHRLS
VARCHAR2(16)
FHPRC
VARCHAR2(20)
FHPRC_I
NUMBER
FHPRS
VARCHAR2(16)
FHBTI
VARCHAR2(20)
FHBSC
VARCHAR2(16)
FHBTH
NUMBER
FHSTA
NUMBER
FHSCN
VARCHAR2(16)
FHTIM
VARCHAR2(20)
FHTHR
NUMBER
FHRBA_SEQ
NUMBER
FHRBA_BNO
NUMBER
FHRBA_BOF
NUMBER
FHETB
RAW(132)
FHCPC
NUMBER
FHRTS
VARCHAR2(20)
FHCCC
NUMBER
FHBCP_SCN
VARCHAR2(16)
FHBCP_TIM
VARCHAR2(20)
FHBCP_THR
NUMBER
FHBCP_RBA_SEQ
NUMBER
FHBCP_RBA_BNO
NUMBER
FHBCP_RBA_BOF
NUMBER
FHBCP_ETB
RAW(132)
FHBHZ
NUMBER
FHXCD
RAW(16)
FHTSN
NUMBER
FHTNM
VARCHAR2(30)
FHRFN
NUMBER
FHAFS
VARCHAR2(16)
FHRFS
VARCHAR2(16)
FHRFT
VARCHAR2(20)
HXIFZ
NUMBER
HXNRCV
NUMBER
HXFNM
VARCHAR2(513)
FHPOFB
NUMBER
FHPNFB
NUMBER
FHPRE10
NUMBER
FHFIRSTUNRECSCN
VARCHAR2(16)
FHFIRSTUNRECTIME
VARCHAR2(20)
HXLMDBA
NUMBER
HXLMLD_SCN
VARCHAR2(16)
DUAL
iSelfSchooling-SQL> desc DUAL;
Name
Null? Type
----------------------------- -------- --------------------
DUMMY
VARCHAR2(1)
GLOBAL_NAME: global database name
iSelfSchooling-SQL> desc GLOBAL_NAME;
Name
Null? Type
----------------------------- -------- --------------------
GLOBAL_NAME
VARCHAR2(4000)
IND: Synonym for USER_INDEXES
iSelfSchooling-SQL> desc IND;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_NAME
NOT NULL VARCHAR2(30)
INDEX_TYPE
VARCHAR2(27)
TABLE_OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
UNIQUENESS
VARCHAR2(9)
COMPRESSION
VARCHAR2(8)
PREFIX_LENGTH
NUMBER
TABLESPACE_NAME
VARCHAR2(30)
INI_TRANS
NUMBER
MAX_TRANS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE
NUMBER
PCT_THRESHOLD
NUMBER
INCLUDE_COLUMN
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
PCT_FREE
NUMBER
LOGGING
VARCHAR2(3)
BLEVEL
NUMBER
LEAF_BLOCKS
NUMBER
DISTINCT_KEYS
NUMBER
AVG_LEAF_BLOCKS_PER_KEY
NUMBER
AVG_DATA_BLOCKS_PER_KEY
NUMBER
CLUSTERING_FACTOR
NUMBER
STATUS
VARCHAR2(8)
NUM_ROWS
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
DEGREE
VARCHAR2(40)
INSTANCES
VARCHAR2(40)
PARTITIONED
VARCHAR2(3)
TEMPORARY
VARCHAR2(1)
GENERATED
VARCHAR2(1)
SECONDARY
VARCHAR2(1)
BUFFER_POOL
VARCHAR2(7)
USER_STATS
VARCHAR2(3)
DURATION
VARCHAR2(15)
PCT_DIRECT_ACCESS
NUMBER
ITYP_OWNER
VARCHAR2(30)
ITYP_NAME
VARCHAR2(30)
PARAMETERS
VARCHAR2(1000)
GLOBAL_STATS
VARCHAR2(3)
DOMIDX_STATUS
VARCHAR2(12)
DOMIDX_OPSTATUS
VARCHAR2(6)
FUNCIDX_STATUS
VARCHAR2(8)
JOIN_INDEX
VARCHAR2(3)
IOT_REDUNDANT_PKEY_ELIM
VARCHAR2(3)
DROPPED
VARCHAR2(3)
INDEX_HISTOGRAM: statistics on keys with repeat count
iSelfSchooling-SQL> desc INDEX_HISTOGRAM;
Name
Null? Type
----------------------------- -------- --------------------
REPEAT_COUNT
NUMBER
KEYS_WITH_REPEAT_COUNT
NUMBER
INDEX_STATS: statistics on the b-tree
iSelfSchooling-SQL> desc INDEX_STATS;
Name
Null?
Type
----------------------------- -------- --------------------
HEIGHT
NUMBER
BLOCKS
NUMBER
NAME
VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
LF_ROWS
NUMBER
LF_BLKS
NUMBER
LF_ROWS_LEN
NUMBER
LF_BLK_LEN
NUMBER
BR_ROWS
NUMBER
BR_BLKS
NUMBER
BR_ROWS_LEN
NUMBER
BR_BLK_LEN
NUMBER
DEL_LF_ROWS
NUMBER
DEL_LF_ROWS_LEN
NUMBER
DISTINCT_KEYS
NUMBER
MOST_REPEATED_KEY
NUMBER
BTREE_SPACE
NUMBER
USED_SPACE
NUMBER
PCT_USED
NUMBER
ROWS_PER_KEY
NUMBER
BLKS_GETS_PER_ACCESS
NUMBER
PRE_ROWS
NUMBER
PRE_ROWS_LEN
NUMBER
OPT_CMPR_COUNT
NUMBER
OPT_CMPR_PCTSAVE
NUMBER
NLS_DATABASE_PARAMETERS: Permanent NLS parameters of the database
iSelfSchooling-SQL> desc NLS_DATABASE_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
PARAMETER
NOT NULL VARCHAR2(30)
VALUE
VARCHAR2(40)
NLS_INSTANCE_PARAMETERS: NLS parameters of the instance
iSelfSchooling-SQL> desc NLS_INSTANCE_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
PARAMETER
VARCHAR2(30)
VALUE
VARCHAR2(40)
NLS_SESSION_PARAMETERS: NLS parameters of the user session
iSelfSchooling-SQL> desc NLS_SESSION_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
PARAMETER
VARCHAR2(30)
VALUE
VARCHAR2(40)
OBJ: Synonym for USER_OBJECTS
iSelfSchooling-SQL> desc OBJ;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_NAME
VARCHAR2(128)
SUBOBJECT_NAME
VARCHAR2(30)
OBJECT_ID
NUMBER
DATA_OBJECT_ID
NUMBER
OBJECT_TYPE
VARCHAR2(19)
CREATED
DATE
LAST_DDL_TIME
DATE
TIMESTAMP
VARCHAR2(19)
STATUS
VARCHAR2(7)
TEMPORARY
VARCHAR2(1)
GENERATED
VARCHAR2(1)
SECONDARY
VARCHAR2(1)
RECYCLEBIN: Synonym for USER_RECYCLEBIN
iSelfSchooling-SQL> desc RECYCLEBIN;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_NAME
NOT NULL VARCHAR2(30)
ORIGINAL_NAME
VARCHAR2(32)
OPERATION
VARCHAR2(9)
TYPE
VARCHAR2(25)
TS_NAME
VARCHAR2(30)
CREATETIME
VARCHAR2(19)
DROPTIME
VARCHAR2(19)
DROPSCN
NUMBER
PARTITION_NAME
VARCHAR2(32)
CAN_UNDROP
VARCHAR2(3)
CAN_PURGE
VARCHAR2(3)
RELATED
NOT NULL NUMBER
BASE_OBJECT
NOT NULL NUMBER
PURGE_OBJECT
NOT NULL NUMBER
SPACE
NUMBER
RESOURCE_COST: Cost for each resource
iSelfSchooling-SQL> desc RESOURCE_COST;
Name
Null? Type
----------------------------- -------- --------------------
RESOURCE_NAME
NOT NULL VARCHAR2(32)
UNIT_COST
NOT NULL NUMBER
ROLE_ROLE_PRIVS: Roles which are granted to roles
iSelfSchooling-SQL> desc ROLE_ROLE_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
ROLE
NOT NULL VARCHAR2(30)
GRANTED_ROLE
NOT NULL VARCHAR2(30)
ADMIN_OPTION
VARCHAR2(3)
ROLE_SYS_PRIVS: System privileges granted to roles
iSelfSchooling-SQL> desc ROLE_SYS_PRIVS;
Name
Null? Type
-----------------------------
-------- --------------------
ROLE
NOT NULL VARCHAR2(30)
PRIVILEGE
NOT NULL VARCHAR2(40)
ADMIN_OPTION
VARCHAR2(3)
ROLE_TAB_PRIVS: Table privileges granted to roles
iSelfSchooling-SQL> desc ROLE_TAB_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
ROLE
NOT NULL VARCHAR2(30)
OWNER
NOT NULL
VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(30)
PRIVILEGE
NOT NULL VARCHAR2(40)
GRANTABLE
VARCHAR2(3)
SEQ: Synonym for USER_SEQUENCES
iSelfSchooling-SQL> desc SEQ;
Name
Null? Type
----------------------------- -------- --------------------
SEQUENCE_NAME
NOT NULL VARCHAR2(30)
MIN_VALUE
NUMBER
MAX_VALUE
NUMBER
INCREMENT_BY
NOT NULL NUMBER
CYCLE_FLAG
VARCHAR2(1)
ORDER_FLAG
VARCHAR2(1)
CACHE_SIZE
NOT NULL NUMBER
LAST_NUMBER
NOT NULL NUMBER
SESSION_PRIVS: Privileges which the user currently has set
iSelfSchooling-SQL> desc SESSION_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
PRIVILEGE
NOT NULL VARCHAR2(40)
SESSION_ROLES: Roles which the user currently has enabled.
iSelfSchooling-SQL> desc SESSION_ROLES;
Name
Null? Type
----------------------------- -------- --------------------
ROLE
NOT NULL VARCHAR2(30)
SM$VERSION: Synonym for SM_$VERSION
iSelfSchooling-SQL> desc SM$VERSION;
Name
Null? Type
----------------------------- -------- --------------------
VERSION_TEXT
CHAR(9)
VERSION_NUMBER
NUMBER
CREATED
DATE
SYN: Synonym for USER_SYNONYMS
iSelfSchooling-SQL> desc SYN;
Name
Null? Type
----------------------------- -------- --------------------
SYNONYM_NAME
NOT NULL VARCHAR2(30)
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
DB_LINK
VARCHAR2(128)
TABLE_PRIVILEGES: Grants on objects for which the user is the
grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
iSelfSchooling-SQL> desc TABLE_PRIVILEGES;
Name
Null? Type
-----------------------------
-------- --------------------
GRANTEE
NOT NULL VARCHAR2(30)
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
GRANTOR
NOT NULL VARCHAR2(30)
SELECT_PRIV
VARCHAR2(1)
INSERT_PRIV
VARCHAR2(1)
DELETE_PRIV
VARCHAR2(1)
UPDATE_PRIV
VARCHAR2(1)
REFERENCES_PRIV
VARCHAR2(1)
ALTER_PRIV
VARCHAR2(1)
INDEX_PRIV
VARCHAR2(1)
CREATED
VARCHAR2
TABS: Synonym for USER_TABLES
iSelfSchooling-SQL> desc TABS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLESPACE_NAME
VARCHAR2(30)
CLUSTER_NAME
VARCHAR2(30)
IOT_NAME
VARCHAR2(30)
STATUS
VARCHAR2(8)
PCT_FREE
NUMBER
PCT_USED
NUMBER
INI_TRANS
NUMBER
MAX_TRANS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
LOGGING
VARCHAR2(3)
BACKED_UP
VARCHAR2(1)
NUM_ROWS
NUMBER
BLOCKS
NUMBER
EMPTY_BLOCKS
NUMBER
AVG_SPACE
NUMBER
CHAIN_CNT
NUMBER
AVG_ROW_LEN
NUMBER
AVG_SPACE_FREELIST_BLOCKS
NUMBER
NUM_FREELIST_BLOCKS
NUMBER
DEGREE
VARCHAR2(10)
INSTANCES
VARCHAR2(10)
CACHE
VARCHAR2(5)
TABLE_LOCK
VARCHAR2(8)
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
PARTITIONED
VARCHAR2(3)
IOT_TYPE
VARCHAR2(12)
TEMPORARY
VARCHAR2(1)
SECONDARY
VARCHAR2(1)
NESTED
VARCHAR2(3)
BUFFER_POOL
VARCHAR2(7)
ROW_MOVEMENT
VARCHAR2(8)
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
DURATION
VARCHAR2(15)
SKIP_CORRUPT
VARCHAR2(8)
MONITORING
VARCHAR2(3)
CLUSTER_OWNER
VARCHAR2(30)
DEPENDENCIES
VARCHAR2(8)
COMPRESSION
VARCHAR2(8)
DROPPED
VARCHAR2(3)
|