ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ALL...
| CLU...
| IND...
| MVI...
| PRO...
| REP...
| SNA...
| TAB...
ALL_CLUSTER_HASH_EXPRESSIONS: Hash functions for all accessible
clusters
iSelfSchooling-SQL> desc ALL_CLUSTER_HASH_EXPRESSIONS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
CLUSTER_NAME
NOT NULL VARCHAR2(30)
HASH_EXPRESSION
LONG
ALL_COLL_TYPES: Description of named collection types
accessible to the user
iSelfSchooling-SQL> desc ALL_COLL_TYPES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TYPE_NAME
NOT NULL VARCHAR2(30)
COLL_TYPE
NOT NULL VARCHAR2(30)
UPPER_BOUND
NUMBER
ELEM_TYPE_MOD
VARCHAR2(7)
ELEM_TYPE_OWNER
VARCHAR2(30)
ELEM_TYPE_NAME
VARCHAR2(30)
LENGTH
NUMBER
PRECISION
NUMBER
SCALE
NUMBER
CHARACTER_SET_NAME
VARCHAR2(44)
ELEM_STORAGE
VARCHAR2(7)
NULLS_STORED
VARCHAR2(3)
ALL_COL_COMMENTS: Comments on columns of accessible
tables and views
iSelfSchooling-SQL> desc ALL_COL_COMMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
ALL_COL_PRIVS: Grants on columns for which the user is
the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
iSelfSchooling-SQL> desc ALL_COL_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)
COLUMN_NAME
NOT NULL VARCHAR2(30)
PRIVILEGE
NOT NULL VARCHAR2(40)
GRANTABLE
VARCHAR2(3)
ALL_COL_PRIVS_MADE: Grants on columns for which the user is
owner or grantor
iSelfSchooling-SQL> desc ALL_COL_PRIVS_MADE;
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)
PRIVILEGE
NOT NULL VARCHAR2(40)
GRANTABLE
VARCHAR2(3)
ALL_COL_PRIVS_RECD: Grants on columns for which the user,
PUBLIC or enabled role is the grantee
iSelfSchooling-SQL> desc ALL_COL_PRIVS_RECD;
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)
PRIVILEGE
NOT
NULL VARCHAR2(40)
GRANTABLE
VARCHAR2(3)
ALL_CONSTRAINTS: Constraint definitions on accessible
tables
iSelfSchooling-SQL> desc ALL_CONSTRAINTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
CONSTRAINT_NAME
NOT NULL VARCHAR2(30)
CONSTRAINT_TYPE
VARCHAR2(1)
TABLE_NAME
NOT NULL VARCHAR2(30)
SEARCH_CONDITION
LONG
R_OWNER
VARCHAR2(30)
R_CONSTRAINT_NAME
VARCHAR2(30)
DELETE_RULE
VARCHAR2(9)
STATUS
VARCHAR2(8)
DEFERRABLE
VARCHAR2(14)
DEFERRED
VARCHAR2(9)
VALIDATED
VARCHAR2(13)
GENERATED
VARCHAR2(14)
BAD
VARCHAR2(3)
RELY
VARCHAR2(4)
LAST_CHANGE
DATE
INDEX_OWNER
VARCHAR2(30)
INDEX_NAME
VARCHAR2(30)
INVALID
VARCHAR2(7)
VIEW_RELATED
VARCHAR2(14)
ALL_CONS_COLUMNS: Information about accessible columns in
constraint definitions
iSelfSchooling-SQL> desc ALL_CONS_COLUMNS;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
CONSTRAINT_NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
POSITION
NUMBER
ALL_CONS_OBJ_COLUMNS: List of types an object column or
attribute is constrained to in the tables accessible to the user
iSelfSchooling-SQL> desc ALL_CONS_OBJ_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
CONS_TYPE_OWNER
VARCHAR2(30)
CONS_TYPE_NAME
VARCHAR2(30)
CONS_TYPE_ONLY
VARCHAR2(15)
ALL_CONTEXT: Description of all active context
namespaces under the current session
iSelfSchooling-SQL> desc ALL_CONTEXT;
Name
Null? Type
----------------------------- -------- --------------------
NAMESPACE
NOT NULL VARCHAR2(30)
SCHEMA
NOT
NULL VARCHAR2(30)
PACKAGE
NOT NULL VARCHAR2(30)
ALL_DB_LINKS: Database links accessible to the user
iSelfSchooling-SQL> desc ALL_DB_LINKS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DB_LINK
NOT NULL VARCHAR2(128)
USERNAME
VARCHAR2(30)
HOST
VARCHAR2(2000)
CREATED
NOT NULL DATE
ALL_DEF_AUDIT_OPTS: Auditing options for newly created
objects
iSelfSchooling-SQL> desc ALL_DEF_AUDIT_OPTS;
Name
Null? Type
----------------------------- -------- --------------------
ALT
VARCHAR2(3)
AUD
VARCHAR2(3)
COM
VARCHAR2(3)
DEL
VARCHAR2(3)
GRA
VARCHAR2(3)
IND
VARCHAR2(3)
INS
VARCHAR2(3)
LOC
VARCHAR2(3)
REN
VARCHAR2(3)
SEL
VARCHAR2(3)
UPD
VARCHAR2(3)
REF
CHAR(3)
EXE
VARCHAR2(3)
FBK
VARCHAR2(3)
REA
VARCHAR2(3)
ALL_DEPENDENCIES: Dependencies to and from objects
accessible to the user
iSelfSchooling-SQL> desc ALL_DEPENDENCIES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL
VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
TYPE
VARCHAR2(17)
REFERENCED_OWNER
VARCHAR2(30)
REFERENCED_NAME
VARCHAR2(64)
REFERENCED_TYPE
VARCHAR2(17)
REFERENCED_LINK_NAME
VARCHAR2(128)
DEPENDENCY_TYPE
VARCHAR2(4)
ALL_DEQUEUE_QUEUES: All queues accessible to the user
iSelfSchooling-SQL> desc ALL_DEQUEUE_QUEUES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
QUEUE_TABLE
NOT
NULL VARCHAR2(30)
QID
NOT NULL NUMBER
QUEUE_TYPE
VARCHAR2(20)
MAX_RETRIES
NUMBER
RETRY_DELAY
NUMBER
ENQUEUE_ENABLED
VARCHAR2(7)
DEQUEUE_ENABLED
VARCHAR2(7)
RETENTION
VARCHAR2(40)
USER_COMMENT
VARCHAR2(50)
NETWORK_NAME
VARCHAR2(512)
ALL_DIMENSIONS: Description of the dimension objects
accessible to the DBA
iSelfSchooling-SQL> desc ALL_DIMENSIONS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DIMENSION_NAME
NOT NULL VARCHAR2(30)
INVALID
VARCHAR2(1)
COMPILE_STATE
VARCHAR2(13)
REVISION
NUMBER
ALL_DIM_ATTRIBUTES: Representation of the relationship
between a dimension level and a functionally dependent column
iSelfSchooling-SQL> desc ALL_DIM_ATTRIBUTES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DIMENSION_NAME
NOT NULL VARCHAR2(30)
ATTRIBUTE_NAME
VARCHAR2(30)
LEVEL_NAME
VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
INFERRED
CHAR(1)
ALL_DIM_CHILD_OF: Representaion of a 1:n hierarchical
relationship between a pair of levels in a dimension
iSelfSchooling-SQL> desc ALL_DIM_CHILD_OF;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DIMENSION_NAME
NOT NULL VARCHAR2(30)
HIERARCHY_NAME
VARCHAR2(30)
POSITION
NOT NULL
NUMBER
CHILD_LEVEL_NAME
VARCHAR2(30)
JOIN_KEY_ID
VARCHAR2(40)
PARENT_LEVEL_NAME
VARCHAR2(30)
ALL_DIM_HIERARCHIES: Representation of a dimension hierarchy
iSelfSchooling-SQL> desc ALL_DIM_HIERARCHIES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DIMENSION_NAME
NOT NULL VARCHAR2(30)
HIERARCHY_NAME
VARCHAR2(30)
ALL_DIM_JOIN_KEY: Representation of a join between two
dimension tables.
iSelfSchooling-SQL> desc ALL_DIM_JOIN_KEY;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DIMENSION_NAME
NOT NULL VARCHAR2(30)
DIM_KEY_ID
NOT NULL NUMBER
LEVEL_NAME
VARCHAR2(30)
KEY_POSITION
NOT NULL NUMBER
HIERARCHY_NAME
VARCHAR2(30)
CHILD_JOIN_OWNER
NOT NULL VARCHAR2(30)
CHILD_JOIN_TABLE
NOT NULL VARCHAR2(30)
CHILD_JOIN_COLUMN
NOT NULL VARCHAR2(30)
CHILD_LEVEL_NAME
VARCHAR2(30)
ALL_DIM_LEVELS: Description of dimension levels visible
to DBA
iSelfSchooling-SQL> desc ALL_DIM_LEVELS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DIMENSION_NAME
NOT NULL VARCHAR2(30)
LEVEL_NAME
VARCHAR2(30)
NUM_COLUMNS
NUMBER
DETAILOBJ_OWNER
NOT NULL VARCHAR2(30)
DETAILOBJ_NAME
NOT NULL VARCHAR2(30)
SKIP_WHEN_NULL
VARCHAR2(1)
ALL_DIM_LEVEL_KEY: Representations of columns of a
dimension level
iSelfSchooling-SQL> desc ALL_DIM_LEVEL_KEY;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DIMENSION_NAME
NOT NULL VARCHAR2(30)
LEVEL_NAME
VARCHAR2(30)
KEY_POSITION
NOT NULL NUMBER
COLUMN_NAME
NOT NULL VARCHAR2(30)
ALL_DIRECTORIES: Description of all directories
accessible to the user
iSelfSchooling-SQL> desc ALL_DIRECTORIES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
DIRECTORY_NAME
NOT NULL VARCHAR2(30)
DIRECTORY_PATH
VARCHAR2(4000)
ALL_ENCRYPTED_COLUMNS: Encryption information on all
accessible columns
iSelfSchooling-SQL> desc ALL_ENCRYPTED_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
ENCRYPTION_ALG
VARCHAR2(29)
SALT
VARCHAR2(3)
ALL_ERRORS: Current errors on stored objects that
user is allowed to create
iSelfSchooling-SQL> desc ALL_ERRORS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
TYPE
VARCHAR2(12)
SEQUENCE
NOT NULL NUMBER
LINE
NOT NULL NUMBER
POSITION
NOT NULL NUMBER
TEXT
NOT NULL VARCHAR2(4000)
ATTRIBUTE
VARCHAR2(9)
MESSAGE_NUMBER
NUMBER
ALL_EVALUATION_CONTEXTS: rule evaluation contexts seen by user
iSelfSchooling-SQL> desc ALL_EVALUATION_CONTEXTS;
Name
Null? Type
----------------------------- -------- --------------------
EVALUATION_CONTEXT_OWNER
NOT NULL VARCHAR2(30)
EVALUATION_CONTEXT_NAME
NOT NULL VARCHAR2(30)
EVALUATION_FUNCTION
VARCHAR2(4000)
EVALUATION_CONTEXT_COMMENT VARCHAR2(4000)
ALL_EVALUATION_CONTEXT_TABLES: tables in all rule evaluation contexts
seen by the user
iSelfSchooling-SQL> desc ALL_EVALUATION_CONTEXT_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
EVALUATION_CONTEXT_OWNER
NOT NULL VARCHAR2(30)
EVALUATION_CONTEXT_NAME
NOT NULL VARCHAR2(30)
TABLE_ALIAS
VARCHAR2(30)
TABLE_NAME
VARCHAR2(4000)
ALL_EVALUATION_CONTEXT_VARS: variables in all rule evaluation
contexts seen by the user
iSelfSchooling-SQL> desc ALL_EVALUATION_CONTEXT_VARS;
Name
Null? Type
----------------------------- -------- --------------------
EVALUATION_CONTEXT_OWNER
NOT NULL VARCHAR2(30)
EVALUATION_CONTEXT_NAME
NOT NULL VARCHAR2(30)
VARIABLE_NAME
VARCHAR2(30)
VARIABLE_TYPE
VARCHAR2(4000)
VARIABLE_VALUE_FUNCTION
VARCHAR2(4000)
VARIABLE_METHOD_FUNCTION
VARCHAR2(228)
ALL_EXTERNAL_LOCATIONS: Description of the external tables
locations accessible to the user
iSelfSchooling-SQL> desc ALL_EXTERNAL_LOCATIONS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
LOCATION
VARCHAR2(4000)
DIRECTORY_OWNER
CHAR(3)
DIRECTORY_NAME
VARCHAR2(30)
ALL_EXTERNAL_TABLES: Description of the external tables
accessible to the user
iSelfSchooling-SQL> desc ALL_EXTERNAL_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
TYPE_OWNER
CHAR(3)
TYPE_NAME
NOT NULL VARCHAR2(30)
DEFAULT_DIRECTORY_OWNER
CHAR(3)
DEFAULT_DIRECTORY_NAME
NOT NULL VARCHAR2(30)
REJECT_LIMIT
VARCHAR2(40)
ACCESS_TYPE
VARCHAR2(7)
ACCESS_PARAMETERS
VARCHAR2(4000)
PROPERTY
VARCHAR2(10)
ALL_FILE_GROUPS: Details about file groups
iSelfSchooling-SQL> desc ALL_FILE_GROUPS;
Name
Null?
Type
----------------------------- -------- --------------------
FILE_GROUP_OWNER
NOT NULL VARCHAR2(30)
FILE_GROUP_NAME
NOT NULL VARCHAR2(30)
KEEP_FILES
NOT NULL VARCHAR2(1)
MIN_VERSIONS
NOT NULL NUMBER
MAX_VERSIONS
NOT NULL NUMBER
RETENTION_DAYS
NOT NULL NUMBER
CREATED
NOT NULL TIMESTAMP(6)
WITH TIME ZONE
COMMENTS
VARCHAR2(4000)
DEFAULT_DIRECTORY
VARCHAR2(30)
ALL_FILE_GROUP_EXPORT_INFO: Details about export information of
file group versions
iSelfSchooling-SQL> desc ALL_FILE_GROUP_EXPORT_INFO;
Name
Null? Type
----------------------------- -------- --------------------
FILE_GROUP_OWNER
NOT NULL VARCHAR2(30)
FILE_GROUP_NAME
NOT NULL VARCHAR2(30)
VERSION_NAME
NOT NULL VARCHAR2(30)
VERSION
NOT NULL NUMBER
EXPORT_VERSION
NOT NULL VARCHAR2(30)
PLATFORM_NAME
NOT NULL VARCHAR2(101)
EXPORT_TIME
NOT NULL DATE
EXPORT_SCN
NUMBER
SOURCE_GLOBAL_NAME
VARCHAR2(128)
ALL_FILE_GROUP_FILES: Details about file group files
iSelfSchooling-SQL> desc ALL_FILE_GROUP_FILES;
Name
Null? Type
----------------------------- -------- --------------------
FILE_GROUP_OWNER
NOT NULL VARCHAR2(30)
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)
ALL_FILE_GROUP_TABLES: Details about the tables in the file
group repository
iSelfSchooling-SQL> desc ALL_FILE_GROUP_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
FILE_GROUP_OWNER
NOT NULL VARCHAR2(30)
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
ALL_FILE_GROUP_TABLESPACES: Details about the transportable
tablespaces in the file group repository
iSelfSchooling-SQL> desc ALL_FILE_GROUP_TABLESPACES;
Name
Null? Type
----------------------------- -------- --------------------
FILE_GROUP_OWNER
NOT NULL VARCHAR2(30)
FILE_GROUP_NAME
NOT NULL VARCHAR2(30)
VERSION_NAME
NOT NULL VARCHAR2(30)
VERSION
NOT NULL NUMBER
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
ALL_FILE_GROUP_VERSIONS: Details about file group versions
iSelfSchooling-SQL> desc ALL_FILE_GROUP_VERSIONS;
Name
Null? Type
----------------------------- -------- --------------------
FILE_GROUP_OWNER
NOT NULL VARCHAR2(30)
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) WITH TI
ME ZONE
COMMENTS
VARCHAR2(4000)
DEFAULT_DIRECTORY
VARCHAR2(30)
ALL_HISTOGRAMS: Synonym for ALL_TAB_HISTOGRAMS
iSelfSchooling-SQL> desc ALL_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_INDEXES: Descriptions of indexes on tables
accessible to the user
iSelfSchooling-SQL> desc ALL_INDEXES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
INDEX_NAME
NOT NULL VARCHAR2(30)
INDEX_TYPE
VARCHAR2(27)
TABLE_OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLE_TYPE
CHAR(5)
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)
ALL_INDEXTYPES: All indextypes available to the user
iSelfSchooling-SQL> desc ALL_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)
|