|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ADV...
| AUD...
| FIL...
| LOB...
| PAR...
| REP...
| SEQ...
| TAB...
USER_FILE_GROUP_FILES: Details about file group files
iSelfSchooling-SQL> desc USER_FILE_GROUP_FILES;
Name
Null? Type
----------------------------- -------- --------------------
FILE_GROUP_NAME
NOT NULL VARCHAR2(30)
VERSION_NAME
NOT NULL VARCHAR2(30)
VERSION
NOT NULL NUMBER
FILE_NAME
NOT NULL VARCHAR2(512)
FILE_DIRECTORY
NOT NULL VARCHAR2(30)
FILE_TYPE
VARCHAR2(32)
FILE_SIZE
NUMBER
FILE_BLOCK_SIZE
NUMBER
COMMENTS
VARCHAR2(4000)
USER_FILE_GROUP_TABLES: Details about the tables in the file
group repository
iSelfSchooling-SQL> desc USER_FILE_GROUP_TABLES;
Name
Null?
Type
----------------------------- -------- --------------------
FILE_GROUP_NAME
NOT NULL VARCHAR2(30)
VERSION_NAME
NOT NULL VARCHAR2(30)
VERSION
NOT NULL NUMBER
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLESPACE_NAME
VARCHAR2(30)
SCN
NUMBER
USER_FILE_GROUP_TABLESPACES: Details about the transportable
tablespaces in the file group repository
iSelfSchooling-SQL> desc USER_FILE_GROUP_TABLESPACES;
Name
Null? Type
----------------------------- -------- --------------------
FILE_GROUP_NAME
NOT NULL VARCHAR2(30)
VERSION_NAME
NOT NULL VARCHAR2(30)
VERSION
NOT NULL NUMBER
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
USER_FILE_GROUP_VERSIONS: Details about file group versions
iSelfSchooling-SQL> desc USER_FILE_GROUP_VERSIONS;
Name
Null? Type
----------------------------- -------- --------------------
FILE_GROUP_NAME
NOT NULL VARCHAR2(30)
VERSION_NAME
NOT NULL VARCHAR2(30)
VERSION
NOT NULL NUMBER
CREATOR
NOT NULL VARCHAR2(30)
CREATED
NOT NULL TIMESTAMP(6)
COMMENTS
VARCHAR2(4000)
DEFAULT_DIRECTORY
VARCHAR2(30)
USER_FREE_SPACE: Free extents in tablespaces accessible
to the user
iSelfSchooling-SQL> desc USER_FREE_SPACE;
Name
Null? Type
----------------------------- -------- --------------------
TABLESPACE_NAME
VARCHAR2(30)
FILE_ID
NUMBER
BLOCK_ID
NUMBER
BYTES
NUMBER
BLOCKS
NUMBER
RELATIVE_FNO
NUMBER
USER_HISTOGRAMS: Synonym for USER_TAB_HISTOGRAMS
iSelfSchooling-SQL> desc USER_HISTOGRAMS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
ENDPOINT_NUMBER
NUMBER
ENDPOINT_VALUE
NUMBER
ENDPOINT_ACTUAL_VALUE
VARCHAR2(1000)
USER_INDEXES: Description of the user's own indexes
iSelfSchooling-SQL> desc USER_INDEXES;
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)
USER_INDEXTYPES: All user indextypes
iSelfSchooling-SQL> desc USER_INDEXTYPES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
INDEXTYPE_NAME
NOT NULL VARCHAR2(30)
IMPLEMENTATION_SCHEMA
NOT NULL VARCHAR2(30)
IMPLEMENTATION_NAME
NOT NULL VARCHAR2(30)
INTERFACE_VERSION
NUMBER
IMPLEMENTATION_VERSION
NOT NULL NUMBER
NUMBER_OF_OPERATORS
NUMBER
PARTITIONING
VARCHAR2(10)
ARRAY_DML
VARCHAR2(3)
USER_INDEXTYPE_ARRAYTYPES: All array types specified by the
indextype
iSelfSchooling-SQL> desc USER_INDEXTYPE_ARRAYTYPES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT
NULL VARCHAR2(30)
INDEXTYPE_NAME
NOT NULL VARCHAR2(30)
BASE_TYPE_SCHEMA
VARCHAR2(30)
BASE_TYPE_NAME
VARCHAR2(30)
BASE_TYPE
VARCHAR2(30)
ARRAY_TYPE_SCHEMA
NOT NULL VARCHAR2(30)
ARRAY_TYPE_NAME
NOT NULL VARCHAR2(30)
USER_INDEXTYPE_COMMENTS: Comments for user-defined indextypes
iSelfSchooling-SQL> desc USER_INDEXTYPE_COMMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
INDEXTYPE_NAME
NOT NULL VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
USER_INDEXTYPE_OPERATORS: All user indextype operators
iSelfSchooling-SQL> desc USER_INDEXTYPE_OPERATORS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
INDEXTYPE_NAME
NOT
NULL VARCHAR2(30)
OPERATOR_SCHEMA
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
BINDING#
NOT NULL NUMBER
USER_IND_COLUMNS: COLUMNs comprising user's INDEXes and
INDEXes on user's TABLES
iSelfSchooling-SQL> desc USER_IND_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_NAME
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
COLUMN_POSITION
NUMBER
COLUMN_LENGTH
NUMBER
CHAR_LENGTH
NUMBER
DESCEND
VARCHAR2(4)
USER_IND_EXPRESSIONS: Functional index expressions in user's
indexes and indexes on user's tables
iSelfSchooling-SQL> desc USER_IND_EXPRESSIONS;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_NAME
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COLUMN_EXPRESSION
LONG
COLUMN_POSITION
NUMBER
USER_IND_PARTITIONS
iSelfSchooling-SQL> desc USER_IND_PARTITIONS;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_NAME
VARCHAR2(30)
COMPOSITE
VARCHAR2(3)
PARTITION_NAME
VARCHAR2(30)
SUBPARTITION_COUNT
NUMBER
HIGH_VALUE
LONG
HIGH_VALUE_LENGTH
NUMBER
PARTITION_POSITION
NUMBER
STATUS
VARCHAR2(8)
TABLESPACE_NAME
VARCHAR2(30)
PCT_FREE
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
| 