|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ALL...
| CLU...
| IND...
| MVI...
| PRO...
| REP...
| SNA...
| TAB...
ALL_TAB_COLS: Columns of user's tables, views and
clusters
iSelfSchooling-SQL> desc ALL_TAB_COLS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
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)
HIDDEN_COLUMN
VARCHAR2(3)
VIRTUAL_COLUMN
VARCHAR2(3)
SEGMENT_COLUMN_ID
NUMBER
INTERNAL_COLUMN_ID
NOT NULL NUMBER
HISTOGRAM
VARCHAR2(15)
QUALIFIED_COL_NAME
VARCHAR2(4000)
ALL_TAB_COLUMNS: Columns of user's tables, views and
clusters
iSelfSchooling-SQL> desc ALL_TAB_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
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)
ALL_TAB_COL_STATISTICS: Columns of user's tables, views and
clusters
iSelfSchooling-SQL> desc ALL_TAB_COL_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(30)
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
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
AVG_COL_LEN
NUMBER
HISTOGRAM
VARCHAR2(15)
ALL_TAB_COMMENTS: Comments on tables and views accessible
to the user
iSelfSchooling-SQL> desc ALL_TAB_COMMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLE_TYPE
VARCHAR2(11)
COMMENTS
VARCHAR2(4000)
ALL_TAB_HISTOGRAMS: Histograms on columns of all tables
visible to user
iSelfSchooling-SQL> desc ALL_TAB_HISTOGRAMS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
ENDPOINT_NUMBER
NUMBER
ENDPOINT_VALUE
NUMBER
ENDPOINT_ACTUAL_VALUE
VARCHAR2(1000)
ALL_TAB_MODIFICATIONS: Information regarding modifications to
tables
iSelfSchooling-SQL> desc ALL_TAB_MODIFICATIONS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
SUBPARTITION_NAME
VARCHAR2(30)
INSERTS
NUMBER
UPDATES
NUMBER
DELETES
NUMBER
TIMESTAMP
DATE
TRUNCATED
VARCHAR2(3)
DROP_SEGMENTS
NUMBER
ALL_TAB_PARTITIONS
iSelfSchooling-SQL> desc ALL_TAB_PARTITIONS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COMPOSITE
VARCHAR2(3)
PARTITION_NAME
VARCHAR2(30)
SUBPARTITION_COUNT
NUMBER
HIGH_VALUE
LONG
HIGH_VALUE_LENGTH
NUMBER
PARTITION_POSITION
NUMBER
TABLESPACE_NAME
VARCHAR2(30)
PCT_FREE
NUMBER
PCT_USED
NUMBER
INI_TRANS
NUMBER
MAX_TRANS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENT
NUMBER
MAX_EXTENT
NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
LOGGING
VARCHAR2(7)
COMPRESSION
VARCHAR2(8)
NUM_ROWS
NUMBER
BLOCKS
NUMBER
EMPTY_BLOCKS
NUMBER
AVG_SPACE
NUMBER
CHAIN_CNT
NUMBER
AVG_ROW_LEN
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
BUFFER_POOL
VARCHAR2(7)
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
ALL_TAB_PRIVS: Grants on objects for which the user is
the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
iSelfSchooling-SQL> desc ALL_TAB_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
GRANTOR
NOT NULL VARCHAR2(30)
GRANTEE
NOT NULL VARCHAR2(30)
TABLE_SCHEMA
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
PRIVILEGE
NOT NULL VARCHAR2(40)
GRANTABLE
VARCHAR2(3)
HIERARCHY
VARCHAR2(3)
ALL_TAB_PRIVS_MADE: User's grants and grants on user's
objects
iSelfSchooling-SQL> desc ALL_TAB_PRIVS_MADE;
Name
Null? Type
|