ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ALL...
| CLU...
| IND...
| MVI...
| PRO...
| REP...
| SNA...
| TAB...
ALL_SNAPSHOT_LOGS: All snapshot logs in the database that
the user can see
iSelfSchooling-SQL> desc ALL_SNAPSHOT_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)
CURRENT_SNAPSHOTS
DATE
SNAPSHOT_ID
NUMBER
ALL_SNAPSHOT_REFRESH_TIMES: Synonym for ALL_MVIEW_REFRESH_TIMES
iSelfSchooling-SQL> desc ALL_SNAPSHOT_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
ALL_SOURCE
Current source on stored objects that
user is allowed to create
iSelfSchooling-SQL> desc ALL_SOURCE;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
NAME
VARCHAR2(30)
TYPE
VARCHAR2(12)
LINE
NUMBER
TEXT
VARCHAR2(4000)
ALL_SOURCE_TABLES: Source tables available for Change Data
Capture
iSelfSchooling-SQL> desc ALL_SOURCE_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
SOURCE_SCHEMA_NAME
NOT NULL VARCHAR2(30)
SOURCE_TABLE_NAME
NOT NULL VARCHAR2(30)
ALL_SQLJ_TYPES: Description of types accessible to the
user
iSelfSchooling-SQL> desc ALL_SQLJ_TYPES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TYPE_NAME
NOT NULL VARCHAR2(30)
TYPE_OID
NOT NULL RAW(16)
EXTERNAL_NAME
VARCHAR2(4000)
USING
VARCHAR2(21)
TYPECODE
VARCHAR2(30)
ATTRIBUTES
NUMBER
METHODS
NUMBER
PREDEFINED
VARCHAR2(3)
INCOMPLETE
VARCHAR2(3)
FINAL
VARCHAR2(3)
INSTANTIABLE
VARCHAR2(3)
SUPERTYPE_OWNER
VARCHAR2(30)
SUPERTYPE_NAME
VARCHAR2(30)
LOCAL_ATTRIBUTES
NUMBER
LOCAL_METHODS
NUMBER
ALL_SQLJ_TYPE_ATTRS: Description of attributes of types
accessible to the user
iSelfSchooling-SQL> desc ALL_SQLJ_TYPE_ATTRS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TYPE_NAME
NOT NULL VARCHAR2(30)
ATTR_NAME
NOT NULL VARCHAR2(30)
EXTERNAL_ATTR_NAME
VARCHAR2(4000)
ATTR_TYPE_MOD
VARCHAR2(7)
ATTR_TYPE_OWNER
VARCHAR2(30)
ATTR_TYPE_NAME
VARCHAR2(30)
LENGTH
NUMBER
PRECISION
NUMBER
SCALE
NUMBER
CHARACTER_SET_NAME
VARCHAR2(44)
ATTR_NO
NOT NULL NUMBER
INHERITED
VARCHAR2(3)
ALL_SQLJ_TYPE_METHODS: Description of methods of types
accessible to the user
iSelfSchooling-SQL> desc ALL_SQLJ_TYPE_METHODS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TYPE_NAME
NOT NULL VARCHAR2(30)
METHOD_NAME
NOT NULL VARCHAR2(30)
EXTERNAL_VAR_NAME
VARCHAR2(4000)
METHOD_NO
NOT NULL NUMBER
METHOD_TYPE
VARCHAR2(6)
PARAMETERS
NOT NULL NUMBER
RESULTS
NOT NULL NUMBER
FINAL
VARCHAR2(3)
INSTANTIABLE
VARCHAR2(3)
OVERRIDING
VARCHAR2(3)
INHERITED
VARCHAR2(3)
ALL_SQLSET
iSelfSchooling-SQL> desc ALL_SQLSET;
Name
Null? Type
----------------------------- -------- --------------------
NAME
NOT NULL VARCHAR2(30)
ID
NOT NULL NUMBER
OWNER
VARCHAR2(30)
DESCRIPTION
VARCHAR2(256)
CREATED
DATE
LAST_MODIFIED
DATE
STATEMENT_COUNT
NUMBER
ALL_SQLSET_BINDS
iSelfSchooling-SQL> desc ALL_SQLSET_BINDS;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
VARCHAR2(30)
SQLSET_OWNER
VARCHAR2(30)
SQLSET_ID
NUMBER
SQL_ID
VARCHAR2(13)
FORCE_MATCHING_SIGNATURE
NUMBER
PLAN_HASH_VALUE
NUMBER
POSITION
NUMBER
VALUE
ANYDATA
CAPTURED
CHAR(1)
SQL_SEQ
NUMBER
ALL_SQLSET_PLANS
iSelfSchooling-SQL> desc ALL_SQLSET_PLANS;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
NOT NULL VARCHAR2(30)
SQLSET_OWNER
VARCHAR2(30)
SQLSET_ID
NOT NULL NUMBER
SQL_ID
NOT NULL VARCHAR2(13)
FORCE_MATCHING_SIGNATURE
NOT NULL NUMBER
PLAN_HASH_VALUE
NOT NULL NUMBER
SQL_SEQ
NOT NULL NUMBER
STATEMENT_ID
VARCHAR2(30)
PLAN_ID
NUMBER
TIMESTAMP
DATE
REMARKS
VARCHAR2(4000)
OPERATION
VARCHAR2(30)
OPTIONS
VARCHAR2(255)
OBJECT_NODE
VARCHAR2(128)
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
OBJECT_ALIAS
VARCHAR2(65)
OBJECT_INSTANCE
NUMBER(38)
OBJECT_TYPE
VARCHAR2(30)
OPTIMIZER
VARCHAR2(255)
SEARCH_COLUMNS
NUMBER
ID
NOT NULL NUMBER(38)
PARENT_ID
NUMBER(38)
DEPTH
NUMBER(38)
POSITION
NUMBER(38)
COST
NUMBER(38)
CARDINALITY
NUMBER(38)
BYTES
NUMBER(38)
OTHER_TAG
VARCHAR2(255)
PARTITION_START
VARCHAR2(255)
PARTITION_STOP
VARCHAR2(255)
PARTITION_ID
NUMBER(38)
OTHER
LONG
DISTRIBUTION
VARCHAR2(30)
CPU_COST
NUMBER(38)
IO_COST
NUMBER(38)
TEMP_SPACE
NUMBER(38)
ACCESS_PREDICATES
VARCHAR2(4000)
FILTER_PREDICATES
VARCHAR2(4000)
PROJECTION
VARCHAR2(4000)
TIME
NUMBER(38)
QBLOCK_NAME
VARCHAR2(30)
OTHER_XML
CLOB
EXECUTIONS
NUMBER
STARTS
NUMBER
OUTPUT_ROWS
NUMBER
CR_BUFFER_GETS
NUMBER
CU_BUFFER_GETS
NUMBER
DISK_READS
NUMBER
DISK_WRITES
NUMBER
ELAPSED_TIME
NUMBER
ALL_SQLSET_REFERENCES
iSelfSchooling-SQL> desc ALL_SQLSET_REFERENCES;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
NOT NULL VARCHAR2(30)
SQLSET_OWNER
VARCHAR2(30)
SQLSET_ID
NOT NULL NUMBER
ID
NOT NULL NUMBER
OWNER
VARCHAR2(30)
DESCRIPTION
VARCHAR2(256)
CREATED
DATE
ALL_SQLSET_STATEMENTS
iSelfSchooling-SQL> desc ALL_SQLSET_STATEMENTS;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
NOT NULL VARCHAR2(30)
SQLSET_OWNER
VARCHAR2(30)
SQLSET_ID
NOT NULL NUMBER
SQL_ID
NOT NULL VARCHAR2(13)
FORCE_MATCHING_SIGNATURE
NOT NULL NUMBER
SQL_TEXT
CLOB
PARSING_SCHEMA_NAME
VARCHAR2(30)
PLAN_HASH_VALUE
NOT NULL NUMBER
BIND_DATA
RAW(2000)
BINDS_CAPTURED
CHAR(1)
MODULE
VARCHAR2(48)
ACTION
VARCHAR2(32)
ELAPSED_TIME
NUMBER
CPU_TIME
NUMBER
BUFFER_GETS
NUMBER
DISK_READS
NUMBER
DIRECT_WRITES
NUMBER
ROWS_PROCESSED
NUMBER
FETCHES
NUMBER
EXECUTIONS
NUMBER
END_OF_FETCH_COUNT
NUMBER
OPTIMIZER_COST
NUMBER
OPTIMIZER_ENV
RAW(1000)
PRIORITY
NUMBER
COMMAND_TYPE
NUMBER
FIRST_LOAD_TIME
VARCHAR2(19)
STAT_PERIOD
NUMBER
ACTIVE_STAT_PERIOD
NUMBER
OTHER
CLOB
PLAN_TIMESTAMP
DATE
SQL_SEQ
NOT NULL NUMBER
ALL_STORED_SETTINGS: Parameter settings for objects
accessible to the user
iSelfSchooling-SQL> desc ALL_STORED_SETTINGS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
OBJECT_ID
NOT NULL NUMBER
OBJECT_TYPE
VARCHAR2(12)
PARAM_NAME
NOT NULL VARCHAR2(30)
PARAM_VALUE
VARCHAR2(4000)
ALL_STREAMS_GLOBAL_RULES: Global rules created on the streams
capture/apply/propagation process that interact with the queue visible to
the current user
iSelfSchooling-SQL> desc ALL_STREAMS_GLOBAL_RULES;
Name
Null? Type
----------------------------- -------- --------------------
STREAMS_NAME
VARCHAR2(30)
STREAMS_TYPE
VARCHAR2(11)
RULE_TYPE
VARCHAR2(7)
INCLUDE_TAGGED_LCR
VARCHAR2(3)
SOURCE_DATABASE
VARCHAR2(128)
RULE_NAME
VARCHAR2(30)
RULE_OWNER
VARCHAR2(30)
RULE_CONDITION
VARCHAR2(4000)
ALL_STREAMS_MESSAGE_CONSUMERS: Streams messaging consumers visible to
the current user
iSelfSchooling-SQL> desc ALL_STREAMS_MESSAGE_CONSUMERS;
Name
Null? Type
----------------------------- -------- --------------------
STREAMS_NAME
NOT NULL VARCHAR2(30)
QUEUE_NAME
NOT NULL VARCHAR2(30)
QUEUE_OWNER
NOT NULL VARCHAR2(30)
RULE_SET_NAME
VARCHAR2(30)
RULE_SET_OWNER
VARCHAR2(30)
NEGATIVE_RULE_SET_NAME
VARCHAR2(30)
NEGATIVE_RULE_SET_OWNER
VARCHAR2(30)
NOTIFICATION_TYPE
VARCHAR2(9)
NOTIFICATION_ACTION
VARCHAR2(256)
NOTIFICATION_CONTEXT
ANYDATA
ALL_STREAMS_MESSAGE_RULES: Rules for Streams messaging visible to
the current user
iSelfSchooling-SQL> desc ALL_STREAMS_MESSAGE_RULES;
Name
Null? Type
----------------------------- -------- --------------------
STREAMS_NAME
NOT NULL VARCHAR2(30)
STREAMS_TYPE
VARCHAR2(11)
MESSAGE_TYPE_NAME
VARCHAR2(30)
MESSAGE_TYPE_OWNER
VARCHAR2(30)
MESSAGE_RULE_VARIABLE
VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_CONDITION
VARCHAR2(4000)
ALL_STREAMS_NEWLY_SUPPORTED: List of tables that are newly supported
by Streams
iSelfSchooling-SQL> desc ALL_STREAMS_NEWLY_SUPPORTED;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
REASON
VARCHAR2(39)
COMPATIBLE
CHAR(4)
ALL_STREAMS_RULES: Rules used by streams processes
iSelfSchooling-SQL> desc ALL_STREAMS_RULES;
Name
Null? Type
----------------------------- -------- --------------------
STREAMS_TYPE
VARCHAR2(11)
STREAMS_NAME
VARCHAR2(30)
RULE_SET_OWNER
VARCHAR2(30)
RULE_SET_NAME
VARCHAR2(30)
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
RULE_CONDITION
CLOB
RULE_SET_TYPE
CHAR(8)
STREAMS_RULE_TYPE
VARCHAR2(6)
SCHEMA_NAME
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
SUBSETTING_OPERATION
VARCHAR2(6)
DML_CONDITION
VARCHAR2(4000)
INCLUDE_TAGGED_LCR
VARCHAR2(3)
SOURCE_DATABASE
VARCHAR2(128)
RULE_TYPE
VARCHAR2(3)
MESSAGE_TYPE_OWNER
VARCHAR2(30)
MESSAGE_TYPE_NAME
VARCHAR2(30)
MESSAGE_RULE_VARIABLE
VARCHAR2(30)
ORIGINAL_RULE_CONDITION
VARCHAR2(4000)
SAME_RULE_CONDITION
VARCHAR2(3)
ALL_STREAMS_SCHEMA_RULES: Rules created by streams administrative
APIs on all user schemas
iSelfSchooling-SQL> desc ALL_STREAMS_SCHEMA_RULES;
Name
Null? Type
----------------------------- -------- --------------------
STREAMS_NAME
VARCHAR2(30)
STREAMS_TYPE
VARCHAR2(11)
SCHEMA_NAME
VARCHAR2(30)
RULE_TYPE
VARCHAR2(7)
INCLUDE_TAGGED_LCR
VARCHAR2(3)
SOURCE_DATABASE
VARCHAR2(128)
RULE_NAME
VARCHAR2(30)
RULE_OWNER
VARCHAR2(30)
RULE_CONDITION
VARCHAR2(4000)
ALL_STREAMS_TABLE_RULES: Rules created by streams administrative
APIs on tables visible to the current user
iSelfSchooling-SQL> desc ALL_STREAMS_TABLE_RULES;
Name
Null? Type
----------------------------- -------- --------------------
STREAMS_NAME
VARCHAR2(30)
STREAMS_TYPE
VARCHAR2(11)
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
RULE_TYPE
VARCHAR2(7)
DML_CONDITION
VARCHAR2(4000)
SUBSETTING_OPERATION
VARCHAR2(6)
INCLUDE_TAGGED_LCR
VARCHAR2(3)
SOURCE_DATABASE
VARCHAR2(128)
RULE_NAME
VARCHAR2(30)
RULE_OWNER
VARCHAR2(30)
RULE_CONDITION
VARCHAR2(4000)
ALL_STREAMS_TRANSFORM_FUNCTION: Rules-based transform functions used by
Streams
iSelfSchooling-SQL> desc ALL_STREAMS_TRANSFORM_FUNCTION;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
NOT NULL
VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
VALUE_TYPE
VARCHAR2(4000)
TRANSFORM_FUNCTION_NAME
VARCHAR2(4000)
CUSTOM_TYPE
VARCHAR2(11)
ALL_STREAMS_UNSUPPORTED: List of all the tables that are not
supported by Streams in this release
iSelfSchooling-SQL> desc ALL_STREAMS_UNSUPPORTED;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
REASON
VARCHAR2(39)
AUTO_FILTERED
VARCHAR2(3)
ALL_SUBPARTITION_TEMPLATES
iSelfSchooling-SQL> desc ALL_SUBPARTITION_TEMPLATES;
Name
Null? Type
----------------------------- -------- --------------------
USER_NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
SUBPARTITION_NAME
NOT NULL VARCHAR2(34)
SUBPARTITION_POSITION
NUMBER
TABLESPACE_NAME
VARCHAR2(30)
HIGH_BOUND
LONG
ALL_SUBPART_COL_STATISTICS
iSelfSchooling-SQL> desc ALL_SUBPART_COL_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
SUBPARTITION_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)
ALL_SUBPART_HISTOGRAMS
iSelfSchooling-SQL> desc ALL_SUBPART_HISTOGRAMS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
SUBPARTITION_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
BUCKET_NUMBER
NUMBER
ENDPOINT_VALUE
NUMBER
ENDPOINT_ACTUAL_VALUE
VARCHAR2(1000)
ALL_SUBPART_KEY_COLUMNS
iSelfSchooling-SQL> desc ALL_SUBPART_KEY_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
NAME
VARCHAR2(30)
OBJECT_TYPE
CHAR(5)
COLUMN_NAME
VARCHAR2(4000)
COLUMN_POSITION
NUMBER
ALL_SUBSCRIBED_COLUMNS: Change Data Capture subscribed columns
iSelfSchooling-SQL> desc ALL_SUBSCRIBED_COLUMNS;
Name
Null?
Type
----------------------------- -------- --------------------
HANDLE
NOT NULL NUMBER
SOURCE_SCHEMA_NAME
NOT NULL VARCHAR2(30)
SOURCE_TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
SUBSCRIPTION_NAME
NOT NULL VARCHAR2(30)
ALL_SUBSCRIBED_TABLES: Change Data Capture subscribed tables
iSelfSchooling-SQL> desc ALL_SUBSCRIBED_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
HANDLE
NOT NULL NUMBER
SOURCE_SCHEMA_NAME
NOT NULL VARCHAR2(30)
SOURCE_TABLE_NAME
NOT NULL VARCHAR2(30)
VIEW_NAME
VARCHAR2(30)
CHANGE_SET_NAME
NOT NULL VARCHAR2(30)
SUBSCRIPTION_NAME
NOT NULL VARCHAR2(30)
ALL_SUBSCRIPTIONS: Change Data Capture subscriptions
iSelfSchooling-SQL> desc ALL_SUBSCRIPTIONS;
Name
Null? Type
----------------------------- -------- --------------------
HANDLE
NOT NULL NUMBER
SET_NAME
NOT NULL VARCHAR2(30)
USERNAME
NOT NULL VARCHAR2(30)
CREATED
NOT NULL DATE
STATUS
NOT NULL VARCHAR2(1)
EARLIEST_SCN
NOT NULL NUMBER
LATEST_SCN
NOT NULL NUMBER
DESCRIPTION
VARCHAR2(255)
LAST_PURGED
DATE
LAST_EXTENDED
DATE
SUBSCRIPTION_NAME
NOT NULL VARCHAR2(30)
ALL_SUMDELTA: Direct path load entries accessible to
the user
iSelfSchooling-SQL> desc ALL_SUMDELTA;
Name
Null? Type
----------------------------- -------- --------------------
TABLEOBJ#
NOT NULL NUMBER
PARTITIONOBJ#
NOT NULL NUMBER
DMLOPERATION
VARCHAR2(1)
SCN
NOT NULL NUMBER
TIMESTAMP
NOT NULL DATE
LOWROWID
NOT NULL ROWID
HIGHROWID
NOT NULL ROWID
SEQUENCE
NUMBER
ALL_SUMMARIES: Description of the summaries accessible
to the user
iSelfSchooling-SQL> desc ALL_SUMMARIES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
SUMMARY_NAME
NOT NULL VARCHAR2(30)
CONTAINER_OWNER
NOT NULL VARCHAR2(30)
CONTAINER_NAME
VARCHAR2(30)
LAST_REFRESH_SCN
NUMBER
LAST_REFRESH_DATE
DATE
REFRESH_METHOD
VARCHAR2(11)
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)
QUERY_LEN
NUMBER
QUERY
LONG
ALL_SYNONYMS: All synonyms for base objects
accessible to the user and session
iSelfSchooling-SQL> desc ALL_SYNONYMS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
SYNONYM_NAME
VARCHAR2(30)
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
DB_LINK
VARCHAR2(128)
ALL_TABLES: Description of relational tables
accessible to the user
iSelfSchooling-SQL> desc ALL_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
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)
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)
|