ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ADV...
| AUD...
| FIL...
| LOB...
| PAR...
| REP...
| SEQ...
| TAB...
USER_LOB_SUBPARTITIONS
iSelfSchooling-SQL> desc USER_LOB_SUBPARTITIONS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
LOB_NAME
NOT NULL VARCHAR2(30)
LOB_PARTITION_NAME
VARCHAR2(30)
SUBPARTITION_NAME
VARCHAR2(30)
LOB_SUBPARTITION_NAME
VARCHAR2(30)
LOB_INDSUBPART_NAME
VARCHAR2(30)
SUBPARTITION_POSITION
NUMBER
CHUNK
NUMBER
PCTVERSION
NOT NULL NUMBER
CACHE
VARCHAR2(10)
IN_ROW
VARCHAR2(3)
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NOT NULL NUMBER
MAX_EXTENTS
NOT NULL NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
LOGGING
VARCHAR2(3)
BUFFER_POOL
VARCHAR2(7)
USER_LOB_TEMPLATES
iSelfSchooling-SQL> desc USER_LOB_TEMPLATES;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
LOB_COL_NAME
VARCHAR2(4000)
SUBPARTITION_NAME
NOT NULL VARCHAR2(34)
LOB_SEGMENT_NAME
NOT NULL VARCHAR2(34)
TABLESPACE_NAME
VARCHAR2(30)
USER_LOG_GROUPS: Log group definitions on user's own
tables
iSelfSchooling-SQL> desc USER_LOG_GROUPS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
LOG_GROUP_NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
LOG_GROUP_TYPE
VARCHAR2(19)
ALWAYS
VARCHAR2(11)
GENERATED
VARCHAR2(14)
USER_LOG_GROUP_COLUMNS: Information about columns in log group
definitions
iSelfSchooling-SQL> desc USER_LOG_GROUP_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
LOG_GROUP_NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
POSITION
NUMBER
LOGGING_PROPERTY
VARCHAR2(6)
USER_METHOD_PARAMS: Description of method parameters of the
user's own types
iSelfSchooling-SQL> desc USER_METHOD_PARAMS;
Name
Null? Type
----------------------------- -------- --------------------
TYPE_NAME
NOT NULL VARCHAR2(30)
METHOD_NAME
NOT NULL VARCHAR2(30)
METHOD_NO
NOT NULL NUMBER
PARAM_NAME
NOT NULL VARCHAR2(30)
PARAM_NO
NOT NULL NUMBER
PARAM_MODE
VARCHAR2(6)
PARAM_TYPE_MOD
VARCHAR2(7)
PARAM_TYPE_OWNER
VARCHAR2(30)
PARAM_TYPE_NAME
VARCHAR2(30)
CHARACTER_SET_NAME
VARCHAR2(44)
USER_METHOD_RESULTS: Description of method results of the
user's own types
iSelfSchooling-SQL> desc USER_METHOD_RESULTS;
Name
Null? Type
----------------------------- -------- --------------------
TYPE_NAME
NOT NULL VARCHAR2(30)
METHOD_NAME
NOT NULL VARCHAR2(30)
METHOD_NO
NOT NULL NUMBER
RESULT_TYPE_MOD
VARCHAR2(7)
RESULT_TYPE_OWNER
VARCHAR2(30)
RESULT_TYPE_NAME
VARCHAR2(30)
CHARACTER_SET_NAME
VARCHAR2(44)
USER_MVIEWS: All materialized views in the database
iSelfSchooling-SQL> desc USER_MVIEWS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
CONTAINER_NAME
NOT NULL VARCHAR2(30)
QUERY
LONG
QUERY_LEN
NUMBER(38)
UPDATABLE
VARCHAR2(1)
UPDATE_LOG
VARCHAR2(30)
MASTER_ROLLBACK_SEG
VARCHAR2(30)
MASTER_LINK
VARCHAR2(128)
REWRITE_ENABLED
VARCHAR2(1)
REWRITE_CAPABILITY
VARCHAR2(9)
REFRESH_MODE
VARCHAR2(6)
REFRESH_METHOD
VARCHAR2(8)
BUILD_MODE
VARCHAR2(9)
FAST_REFRESHABLE
VARCHAR2(18)
LAST_REFRESH_TYPE
VARCHAR2(8)
LAST_REFRESH_DATE
DATE
STALENESS
VARCHAR2(19)
AFTER_FAST_REFRESH
VARCHAR2(19)
UNKNOWN_PREBUILT
VARCHAR2(1)
UNKNOWN_PLSQL_FUNC
VARCHAR2(1)
UNKNOWN_EXTERNAL_TABLE
VARCHAR2(1)
UNKNOWN_CONSIDER_FRESH
VARCHAR2(1)
UNKNOWN_IMPORT
VARCHAR2(1)
UNKNOWN_TRUSTED_FD
VARCHAR2(1)
COMPILE_STATE
VARCHAR2(19)
USE_NO_INDEX
VARCHAR2(1)
STALE_SINCE
DATE
USER_MVIEW_AGGREGATES: Description of the materialized view
aggregates created by the user
iSelfSchooling-SQL> desc USER_MVIEW_AGGREGATES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
POSITION_IN_SELECT
NOT NULL NUMBER
CONTAINER_COLUMN
NOT NULL VARCHAR2(30)
AGG_FUNCTION
VARCHAR2(8)
DISTINCTFLAG
VARCHAR2(1)
MEASURE
LONG
USER_MVIEW_ANALYSIS: Description of the materialized views
created by the user
iSelfSchooling-SQL> desc USER_MVIEW_ANALYSIS;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
MVIEW_TABLE_OWNER
NOT NULL VARCHAR2(30)
CONTAINER_NAME
VARCHAR2(30)
LAST_REFRESH_SCN
NUMBER
LAST_REFRESH_DATE
DATE
REFRESH_METHOD
VARCHAR2(8)
SUMMARY
VARCHAR2(1)
FULLREFRESHTIM
NUMBER
INCREFRESHTIM
NUMBER
CONTAINS_VIEWS
VARCHAR2(1)
UNUSABLE
VARCHAR2(1)
RESTRICTED_SYNTAX
VARCHAR2(1)
INC_REFRESHABLE
VARCHAR2(1)
KNOWN_STALE
VARCHAR2(1)
INVALID
VARCHAR2(1)
REWRITE_ENABLED
VARCHAR2(1)
QUERY_LEN
NUMBER
QUERY
LONG
REVISION
NOT NULL NUMBER
USER_MVIEW_COMMENTS: Comments on materialized views owned by
the user
iSelfSchooling-SQL> desc USER_MVIEW_COMMENTS;
Name
Null? Type
----------------------------- -------- --------------------
MVIEW_NAME
NOT NULL VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
USER_MVIEW_DETAIL_RELATIONS: Description of the materialized view
detail tables of the materialized views created by the user
iSelfSchooling-SQL> desc USER_MVIEW_DETAIL_RELATIONS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
DETAILOBJ_OWNER
NOT NULL VARCHAR2(30)
DETAILOBJ_NAME
NOT NULL VARCHAR2(30)
DETAILOBJ_TYPE
VARCHAR2(9)
DETAILOBJ_ALIAS
VARCHAR2(30)
USER_MVIEW_JOINS: Description of a join between two
columns in the WHERE clause of a materialized view created by the user
iSelfSchooling-SQL> desc USER_MVIEW_JOINS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT
NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
DETAILOBJ1_OWNER
NOT NULL VARCHAR2(30)
DETAILOBJ1_RELATION
NOT NULL VARCHAR2(30)
DETAILOBJ1_COLUMN
NOT NULL VARCHAR2(30)
OPERATOR
CHAR(1)
OPERATOR_TYPE
VARCHAR2(1)
DETAILOBJ2_OWNER
NOT NULL VARCHAR2(30)
DETAILOBJ2_RELATION
NOT NULL VARCHAR2(30)
DETAILOBJ2_COLUMN
NOT NULL VARCHAR2(30)
USER_MVIEW_KEYS: Description of the columns that appear
in the GROUP BY list of a materialized view created by the user
iSelfSchooling-SQL> desc USER_MVIEW_KEYS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
POSITION_IN_SELECT
NOT NULL NUMBER
CONTAINER_COLUMN
NOT NULL VARCHAR2(30)
DETAILOBJ_OWNER
NOT NULL VARCHAR2(30)
DETAILOBJ_NAME
NOT NULL VARCHAR2(30)
DETAILOBJ_ALIAS
VARCHAR2(30)
DETAILOBJ_TYPE
VARCHAR2(5)
DETAILOBJ_COLUMN
NOT NULL VARCHAR2(30)
USER_MVIEW_LOGS: All materialized view logs owned by the
user
iSelfSchooling-SQL> desc USER_MVIEW_LOGS;
Name
Null? Type
----------------------------- -------- --------------------
LOG_OWNER
VARCHAR2(30)
MASTER
VARCHAR2(30)
LOG_TABLE
VARCHAR2(30)
LOG_TRIGGER
VARCHAR2(30)
ROWIDS
VARCHAR2(3)
PRIMARY_KEY
VARCHAR2(3)
OBJECT_ID
VARCHAR2(3)
FILTER_COLUMNS
VARCHAR2(3)
SEQUENCE
VARCHAR2(3)
INCLUDE_NEW_VALUES
VARCHAR2(3)
USER_MVIEW_REFRESH_TIMES: Materialized views and their last
refresh times for each master table that the user can look at
iSelfSchooling-SQL> desc USER_MVIEW_REFRESH_TIMES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
MASTER_OWNER
VARCHAR2(30)
MASTER
VARCHAR2(30)
LAST_REFRESH
DATE
USER_NESTED_TABLES: Description of nested tables contained
in the user's own tables
iSelfSchooling-SQL> desc USER_NESTED_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
TABLE_TYPE_OWNER
VARCHAR2(30)
TABLE_TYPE_NAME
VARCHAR2(30)
PARENT_TABLE_NAME
VARCHAR2(30)
PARENT_TABLE_COLUMN
VARCHAR2(4000)
STORAGE_SPEC
VARCHAR2(30)
RETURN_TYPE
VARCHAR2(20)
ELEMENT_SUBSTITUTABLE
VARCHAR2(25)
USER_NESTED_TABLE_COLS: Columns of nested tables
iSelfSchooling-SQL> desc USER_NESTED_TABLE_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)
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)
USER_OBJECTS: Objects owned by the user
iSelfSchooling-SQL> desc USER_OBJECTS;
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)
USER_OBJECT_SIZE: Sizes, in bytes, of various pl/sql
objects
iSelfSchooling-SQL> desc USER_OBJECT_SIZE;
Name
Null? Type
----------------------------- -------- --------------------
NAME
NOT
NULL VARCHAR2(30)
TYPE
VARCHAR2(13)
SOURCE_SIZE
NUMBER
PARSED_SIZE
NUMBER
CODE_SIZE
NUMBER
ERROR_SIZE
NUMBER
USER_OBJECT_TABLES: Description of the user's own object
tables
iSelfSchooling-SQL> desc USER_OBJECT_TABLES;
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)
OBJECT_ID_TYPE
VARCHAR2(16)
TABLE_TYPE_OWNER
VARCHAR2(30)
TABLE_TYPE
VARCHAR2(30)
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)
USER_OBJ_AUDIT_OPTS: Auditing options for user's own tables
and views with atleast one option set
iSelfSchooling-SQL> desc USER_OBJ_AUDIT_OPTS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_NAME
VARCHAR2(30)
OBJECT_TYPE
VARCHAR2(17)
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)
CRE
VARCHAR2(3)
REA
VARCHAR2(3)
WRI
VARCHAR2(3)
FBK
VARCHAR2(3)
USER_OBJ_COLATTRS: Description of object columns and
attributes contained in tables owned by the user
iSelfSchooling-SQL> desc USER_OBJ_COLATTRS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
SUBSTITUTABLE
VARCHAR2(15)
USER_OPANCILLARY: All ancillary operators defined by user
iSelfSchooling-SQL> desc USER_OPANCILLARY;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
BINDING#
NOT NULL NUMBER
PRIMOP_OWNER
NOT NULL VARCHAR2(30)
PRIMOP_NAME
NOT NULL VARCHAR2(30)
PRIMOP_BIND#
NOT NULL NUMBER
USER_OPARGUMENTS: All operator arguments of operators
defined by user
iSelfSchooling-SQL> desc USER_OPARGUMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
BINDING#
NOT NULL NUMBER
POSITION
NOT NULL NUMBER
ARGUMENT_TYPE
VARCHAR2(61)
USER_OPBINDINGS: All binding functions or methods on
operators defined by the user
iSelfSchooling-SQL> desc USER_OPBINDINGS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
BINDING#
NOT NULL NUMBER
FUNCTION_NAME
VARCHAR2(92)
RETURN_SCHEMA
VARCHAR2(30)
RETURN_TYPE
VARCHAR2(30)
IMPLEMENTATION_TYPE_SCHEMA VARCHAR2(30)
IMPLEMENTATION_TYPE
VARCHAR2(30)
PROPERTY
VARCHAR2(43)
USER_OPERATORS: All user operators
iSelfSchooling-SQL> desc USER_OPERATORS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
NUMBER_OF_BINDS
NOT NULL NUMBER
USER_OPERATOR_COMMENTS: Comments for user-defined operators
iSelfSchooling-SQL> desc USER_OPERATOR_COMMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OPERATOR_NAME
NOT NULL VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
USER_OUTLINES: Stored outlines owned by the user
iSelfSchooling-SQL> desc USER_OUTLINES;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(30)
CATEGORY
VARCHAR2(30)
USED
VARCHAR2(6)
TIMESTAMP
DATE
VERSION
VARCHAR2(64)
SQL_TEXT
LONG
SIGNATURE
RAW(16)
COMPATIBLE
VARCHAR2(12)
ENABLED
VARCHAR2(8)
FORMAT
VARCHAR2(6)
USER_OUTLINE_HINTS: Hints stored in outlines owned by the
user
iSelfSchooling-SQL> desc USER_OUTLINE_HINTS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(30)
NODE
NUMBER
STAGE
NUMBER
JOIN_POS
NUMBER
HINT
CLOB
USER_PARTIAL_DROP_TABS: User tables with unused columns
iSelfSchooling-SQL> desc USER_PARTIAL_DROP_TABS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
USER_PART_COL_STATISTICS
iSelfSchooling-SQL> desc USER_PART_COL_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
NUM_DISTINCT
NUMBER
LOW_VALUE
RAW(32)
HIGH_VALUE
RAW(32)
DENSITY
NUMBER
NUM_NULLS
NUMBER
NUM_BUCKETS
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
AVG_COL_LEN
NUMBER
HISTOGRAM
VARCHAR2(15)
USER_PART_HISTOGRAMS
iSelfSchooling-SQL> desc USER_PART_HISTOGRAMS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
BUCKET_NUMBER
NUMBER
ENDPOINT_VALUE
NUMBER
ENDPOINT_ACTUAL_VALUE
VARCHAR2(1000)
USER_PART_INDEXES
iSelfSchooling-SQL> desc USER_PART_INDEXES;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
PARTITIONING_TYPE
VARCHAR2(7)
SUBPARTITIONING_TYPE
VARCHAR2(7)
PARTITION_COUNT
NOT NULL NUMBER
DEF_SUBPARTITION_COUNT
NUMBER
PARTITIONING_KEY_COUNT
NOT NULL NUMBER
SUBPARTITIONING_KEY_COUNT
NUMBER
LOCALITY
VARCHAR2(6)
ALIGNMENT
VARCHAR2(12)
DEF_TABLESPACE_NAME
VARCHAR2(30)
DEF_PCT_FREE
NOT NULL NUMBER
DEF_INI_TRANS
NOT NULL NUMBER
DEF_MAX_TRANS
NOT NULL NUMBER
DEF_INITIAL_EXTENT
VARCHAR2(40)
DEF_NEXT_EXTENT
VARCHAR2(40)
DEF_MIN_EXTENTS
VARCHAR2(40)
DEF_MAX_EXTENTS
VARCHAR2(40)
DEF_PCT_INCREASE
VARCHAR2(40)
DEF_FREELISTS
NOT NULL NUMBER
DEF_FREELIST_GROUPS
NOT NULL NUMBER
DEF_LOGGING
VARCHAR2(7)
DEF_BUFFER_POOL
VARCHAR2(7)
DEF_PARAMETERS
VARCHAR2(1000)
|