ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ADV...
| AUD...
| FIL...
| LOB...
| PAR...
| REP...
| SEQ...
| TAB...
USER_SEQUENCES: Description of the user's own SEQUENCEs
iSelfSchooling-SQL> desc USER_SEQUENCES;
Name
Null? Type
----------------------------- -------- --------------------
SEQUENCE_NAME
NOT NULL VARCHAR2(30)
MIN_VALUE
NUMBER
MAX_VALUE
NUMBER
INCREMENT_BY
NOT NULL NUMBER
CYCLE_FLAG
VARCHAR2(1)
ORDER_FLAG
VARCHAR2(1)
CACHE_SIZE
NOT NULL NUMBER
LAST_NUMBER
NOT NULL NUMBER
USER_SNAPSHOTS: Snapshots the user can look at
iSelfSchooling-SQL> desc USER_SNAPSHOTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
MASTER_VIEW
VARCHAR2(30)
MASTER_OWNER
VARCHAR2(30)
MASTER
VARCHAR2(30)
MASTER_LINK
VARCHAR2(128)
CAN_USE_LOG
VARCHAR2(3)
UPDATABLE
VARCHAR2(3)
REFRESH_METHOD
VARCHAR2(11)
LAST_REFRESH
DATE
ERROR
NUMBER
FR_OPERATIONS
VARCHAR2(10)
CR_OPERATIONS
VARCHAR2(10)
TYPE
VARCHAR2(8)
NEXT
VARCHAR2(200)
START_WITH
DATE
REFRESH_GROUP
NUMBER
UPDATE_TRIG
VARCHAR2(30)
UPDATE_LOG
VARCHAR2(30)
QUERY
LONG
MASTER_ROLLBACK_SEG
VARCHAR2(30)
STATUS
VARCHAR2(7)
REFRESH_MODE
VARCHAR2(8)
PREBUILT
VARCHAR2(3)
USER_SNAPSHOT_LOGS: All snapshot logs owned by the user
iSelfSchooling-SQL> desc USER_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
USER_SNAPSHOT_REFRESH_TIMES: Synonym for USER_MVIEW_REFRESH_TIMES
iSelfSchooling-SQL> desc USER_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
USER_SOURCE: Source of stored objects accessible to
the user
iSelfSchooling-SQL> desc USER_SOURCE;
Name
Null?
Type
----------------------------- -------- --------------------
NAME
VARCHAR2(30)
TYPE
VARCHAR2(12)
LINE
NUMBER
TEXT
VARCHAR2(4000)
USER_SOURCE_TABLES: Source tables available for Change Data
Capture
iSelfSchooling-SQL> desc USER_SOURCE_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
SOURCE_SCHEMA_NAME
NOT NULL VARCHAR2(30)
SOURCE_TABLE_NAME
NOT NULL VARCHAR2(30)
USER_SQLJ_TYPES: Description of the user's own types
iSelfSchooling-SQL> desc USER_SQLJ_TYPES;
Name
Null? Type
----------------------------- -------- --------------------
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
USER_SQLJ_TYPE_ATTRS: Description of attributes of the user's
own types
iSelfSchooling-SQL> desc USER_SQLJ_TYPE_ATTRS;
Name
Null? Type
----------------------------- -------- --------------------
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)
USER_SQLJ_TYPE_METHODS: Description of methods of the user's own types
iSelfSchooling-SQL> desc USER_SQLJ_TYPE_METHODS;
Name
Null? Type
----------------------------- -------- --------------------
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)
USER_SQLSET
iSelfSchooling-SQL> desc USER_SQLSET;
Name
Null? Type
----------------------------- -------- --------------------
NAME
NOT NULL VARCHAR2(30)
ID
NOT NULL NUMBER
DESCRIPTION
VARCHAR2(256)
CREATED
DATE
LAST_MODIFIED
DATE
STATEMENT_COUNT
NUMBER
USER_SQLSET_BINDS
iSelfSchooling-SQL> desc USER_SQLSET_BINDS;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
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
USER_SQLSET_DEFINITIONS: Synonym for USER_SQLSET
iSelfSchooling-SQL> desc USER_SQLSET_DEFINITIONS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
NOT NULL VARCHAR2(30)
ID
NOT NULL NUMBER
DESCRIPTION
VARCHAR2(256)
CREATED
DATE
LAST_MODIFIED
DATE
STATEMENT_COUNT
NUMBER
USER_SQLSET_PLANS
iSelfSchooling-SQL> desc USER_SQLSET_PLANS;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
NOT NULL 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
USER_SQLSET_REFERENCES
iSelfSchooling-SQL> desc USER_SQLSET_REFERENCES;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
NOT
NULL VARCHAR2(30)
SQLSET_ID
NOT NULL NUMBER
ID
NOT NULL NUMBER
OWNER
VARCHAR2(30)
DESCRIPTION
VARCHAR2(256)
CREATED
DATE
USER_SQLSET_STATEMENTS
iSelfSchooling-SQL> desc USER_SQLSET_STATEMENTS;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
NOT NULL 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)
PARSING_SCHEMA_ID
NUMBER
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
USER_SQLTUNE_BINDS
iSelfSchooling-SQL> desc USER_SQLTUNE_BINDS;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER(38)
OBJECT_ID
NOT NULL NUMBER(38)
POSITION
NOT NULL NUMBER(38)
VALUE
ANYDATA
USER_SQLTUNE_PLANS
iSelfSchooling-SQL> desc USER_SQLTUNE_PLANS;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER(38)
OBJECT_ID NOT
NULL NUMBER(38)
ATTRIBUTE
VARCHAR2(27)
STATEMENT_ID
VARCHAR2(30)
PLAN_HASH_VALUE
NOT NULL NUMBER
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
USER_SQLTUNE_RATIONALE_PLAN
iSelfSchooling-SQL> desc USER_SQLTUNE_RATIONALE_PLAN;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER(38)
RATIONALE_ID
NOT NULL NUMBER(38)
OBJECT_ID
NOT
NULL NUMBER(38)
OPERATION_ID
NOT NULL NUMBER(38)
PLAN_ATTRIBUTE
VARCHAR2(27)
USER_SQLTUNE_STATISTICS
iSelfSchooling-SQL> desc USER_SQLTUNE_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER(38)
OBJECT_ID
NOT NULL NUMBER(38)
PARSING_SCHEMA_ID
NUMBER
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)
COMMAND_TYPE
NUMBER
USER_STORED_SETTINGS: Parameter settings for objects owned by
the user
iSelfSchooling-SQL> desc USER_STORED_SETTINGS;
Name
Null?
Type
----------------------------- -------- --------------------
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)
USER_SUBPARTITION_TEMPLATES
iSelfSchooling-SQL> desc USER_SUBPARTITION_TEMPLATES;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
SUBPARTITION_NAME
NOT NULL VARCHAR2(34)
SUBPARTITION_POSITION
NUMBER
TABLESPACE_NAME
VARCHAR2(30)
HIGH_BOUND
LONG
USER_SUBPART_COL_STATISTICS
iSelfSchooling-SQL> desc USER_SUBPART_COL_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
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)
USER_SUBPART_HISTOGRAMS
iSelfSchooling-SQL> desc USER_SUBPART_HISTOGRAMS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
SUBPARTITION_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
BUCKET_NUMBER
NUMBER
ENDPOINT_VALUE
NUMBER
ENDPOINT_ACTUAL_VALUE
VARCHAR2(1000)
USER_SUBPART_KEY_COLUMNS
iSelfSchooling-SQL> desc USER_SUBPART_KEY_COLUMNS;
Name
Null?
Type
----------------------------- -------- --------------------
NAME
VARCHAR2(30)
OBJECT_TYPE
CHAR(5)
COLUMN_NAME
VARCHAR2(4000)
COLUMN_POSITION
NUMBER
USER_SUBSCRIBED_COLUMNS: Change Data Capture subscribed columns
iSelfSchooling-SQL> desc USER_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)
USER_SUBSCRIBED_TABLES: Change Data Capture subscribed tables
iSelfSchooling-SQL> desc USER_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)
USER_SUBSCRIPTIONS: Change Data Capture subscriptions
iSelfSchooling-SQL> desc USER_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)
USER_SUMMARIES: Description of the summaries created by
the user
iSelfSchooling-SQL> desc USER_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
USER_SYNONYMS: The user's private synonyms
iSelfSchooling-SQL> desc USER_SYNONYMS;
Name
Null? Type
----------------------------- -------- --------------------
SYNONYM_NAME
NOT NULL VARCHAR2(30)
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
DB_LINK
VARCHAR2(128)
USER_SYS_PRIVS: System privileges granted to current
user
iSelfSchooling-SQL> desc USER_SYS_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
USERNAME
VARCHAR2(30)
PRIVILEGE
NOT NULL VARCHAR2(40)
ADMIN_OPTION
VARCHAR2(3)
USER_TABLES: Description of the user's own
relational tables
iSelfSchooling-SQL> desc USER_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)
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_TABLESPACES: Description of accessible tablespaces
iSelfSchooling-SQL> desc USER_TABLESPACES;
Name
Null? Type
----------------------------- -------- --------------------
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
BLOCK_SIZE
NOT NULL NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NOT NULL NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE
NUMBER
MIN_EXTLEN
NUMBER
STATUS
VARCHAR2(9)
CONTENTS
VARCHAR2(9)
LOGGING
VARCHAR2(9)
FORCE_LOGGING
VARCHAR2(3)
EXTENT_MANAGEMENT
VARCHAR2(10)
ALLOCATION_TYPE
VARCHAR2(9)
SEGMENT_SPACE_MANAGEMENT
VARCHAR2(6)
DEF_TAB_COMPRESSION
VARCHAR2(8)
RETENTION
VARCHAR2(11)
BIGFILE
VARCHAR2(3)
|