|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ALL...
| CLU...
| IND...
| MVI...
| PRO...
| REP...
| SNA...
| TAB...
ALL_INDEXTYPE_ARRAYTYPES: All array types specified by the
indextype
iSelfSchooling-SQL> desc ALL_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)
ALL_INDEXTYPE_COMMENTS: Comments for user-defined indextypes
iSelfSchooling-SQL> desc ALL_INDEXTYPE_COMMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
INDEXTYPE_NAME
NOT NULL VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
ALL_INDEXTYPE_OPERATORS: All operators available to the user
iSelfSchooling-SQL> desc ALL_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
ALL_IND_COLUMNS: COLUMNs comprising INDEXes on
accessible TABLES
iSelfSchooling-SQL> desc ALL_IND_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_OWNER
NOT NULL VARCHAR2(30)
INDEX_NAME
NOT NULL VARCHAR2(30)
TABLE_OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
COLUMN_POSITION
NOT NULL NUMBER
COLUMN_LENGTH
NOT NULL NUMBER
CHAR_LENGTH
NUMBER
DESCEND
VARCHAR2(4)
ALL_IND_EXPRESSIONS: FUNCTIONAL INDEX EXPRESSIONs on
accessible TABLES
iSelfSchooling-SQL> desc ALL_IND_EXPRESSIONS;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_OWNER
NOT NULL VARCHAR2(30)
INDEX_NAME
NOT NULL VARCHAR2(30)
TABLE_OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_EXPRESSION
LONG
COLUMN_POSITION
NOT NULL NUMBER
ALL_IND_PARTITIONS
iSelfSchooling-SQL> desc ALL_IND_PARTITIONS;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_OWNER
VARCHAR2(30)
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
LOGGING
VARCHAR2(7)
COMPRESSION
VARCHAR2(8)
BLEVEL
NUMBER
LEAF_BLOCKS
NUMBER
DISTINCT_KEYS
NUMBER
AVG_LEAF_BLOCKS_PER_KEY
NUMBER
AVG_DATA_BLOCKS_PER_KEY
NUMBER
CLUSTERING_FACTOR
NUMBER
NUM_ROWS
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
BUFFER_POOL
VARCHAR2(7)
USER_STATS
VARCHAR2(3)
PCT_DIRECT_ACCESS
NUMBER
GLOBAL_STATS
VARCHAR2(3)
DOMIDX_OPSTATUS
VARCHAR2(6)
PARAMETERS
VARCHAR2(1000)
ALL_IND_STATISTICS: Optimizer statistics for all indexes on
tables accessible to the user
iSelfSchooling-SQL> desc ALL_IND_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
INDEX_NAME
VARCHAR2(30)
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
PARTITION_POSITION
NUMBER
SUBPARTITION_NAME
VARCHAR2(30)
SUBPARTITION_POSITION
NUMBER
OBJECT_TYPE
VARCHAR2(12)
BLEVEL
NUMBER
LEAF_BLOCKS
NUMBER
DISTINCT_KEYS
NUMBER
AVG_LEAF_BLOCKS_PER_KEY
NUMBER
AVG_DATA_BLOCKS_PER_KEY
NUMBER
CLUSTERING_FACTOR
NUMBER
NUM_ROWS
NUMBER
AVG_CACHED_BLOCKS
NUMBER
AVG_CACHE_HIT_RATIO
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
STATTYPE_LOCKED
VARCHAR2(5)
STALE_STATS
VARCHAR2(3)
ALL_IND_SUBPARTITIONS
iSelfSchooling-SQL> desc ALL_IND_SUBPARTITIONS;
Name
Null?
Type
----------------------------- -------- --------------------
INDEX_OWNER
NOT NULL VARCHAR2(30)
INDEX_NAME
NOT NULL VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
SUBPARTITION_NAME VARCHAR2(30)
HIGH_VALUE
LONG
HIGH_VALUE_LENGTH
NOT NULL NUMBER
SUBPARTITION_POSITION
NUMBER
STATUS
VARCHAR2(8)
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
PCT_FREE
NOT NULL NUMBER
INI_TRANS
NOT NULL NUMBER
MAX_TRANS
NOT NULL NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENT
NOT NULL NUMBER
MAX_EXTENT
NOT NULL NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
LOGGING
VARCHAR2(3)
COMPRESSION
VARCHAR2(8)
BLEVEL
NUMBER
LEAF_BLOCKS
NUMBER
DISTINCT_KEYS
NUMBER
AVG_LEAF_BLOCKS_PER_KEY
NUMBER
AVG_DATA_BLOCKS_PER_KEY
NUMBER
CLUSTERING_FACTOR
NUMBER
NUM_ROWS
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
BUFFER_POOL
VARCHAR2(7)
USER_STATS
VARCHAR2(3)
GLOBAL_STATS
VARCHAR2(3)
ALL_INTERNAL_TRIGGERS: Description of the internal triggers on
the tables accessible to the user
iSelfSchooling-SQL> desc ALL_INTERNAL_TRIGGERS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
INTERNAL_TRIGGER_TYPE
VARCHAR2(19)
ALL_JAVA_ARGUMENTS: argument information of stored java
class accessible to the user
iSelfSchooling-SQL> desc ALL_JAVA_ARGUMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
VARCHAR2(4000)
METHOD_INDEX
NUMBER
METHOD_NAME
VARCHAR2(4000)
ARGUMENT_POSITION
NUMBER
ARRAY_DEPTH
NUMBER
BASE_TYPE
VARCHAR2(7)
ARGUMENT_CLASS
VARCHAR2(4000)
ALL_JAVA_CLASSES: class level information of stored java
class accessible to the user
iSelfSchooling-SQL> desc ALL_JAVA_CLASSES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME &nbs |