Description of oracle dba dictionary views:
SQL> desc dba_alert_history;
Name Null? Type
----------------------------------------- --------
----------------------------
SEQUENCE_ID NOT NULL NUMBER
REASON_ID NUMBER
OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(513)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_TYPE VARCHAR2(64)
REASON VARCHAR2(4000)
TIME_SUGGESTED TIMESTAMP(6) WITH TIME
ZONE
CREATION_TIME TIMESTAMP(6) WITH TIME
ZONE
SUGGESTED_ACTION VARCHAR2(4000)
ADVISOR_NAME VARCHAR2(30)
METRIC_VALUE NUMBER
MESSAGE_TYPE VARCHAR2(12)
MESSAGE_GROUP VARCHAR2(64)
MESSAGE_LEVEL NUMBER
HOSTING_CLIENT_ID VARCHAR2(64)
MODULE_ID VARCHAR2(64)
PROCESS_ID VARCHAR2(128)
HOST_ID VARCHAR2(256)
HOST_NW_ADDR VARCHAR2(256)
INSTANCE_NAME VARCHAR2(16)
INSTANCE_NUMBER NUMBER
USER_ID VARCHAR2(30)
EXECUTION_CONTEXT_ID VARCHAR2(60)
ERROR_INSTANCE_ID VARCHAR2(142)
RESOLUTION VARCHAR2(7)
SQL> desc dba_all_tables;
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
TABLE_NAME 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)
SQL> desc dba_application_roles;
Name Null? Type
----------------------------------------- --------
----------------------------
ROLE NOT NULL VARCHAR2(30)
SCHEMA NOT NULL VARCHAR2(30)
PACKAGE NOT NULL VARCHAR2(30)
SQL> desc dba_apply;
Name Null? Type
----------------------------------------- --------
----------------------------
APPLY_NAME NOT NULL VARCHAR2(30)
QUEUE_NAME NOT NULL VARCHAR2(30)
QUEUE_OWNER NOT NULL VARCHAR2(30)
APPLY_CAPTURED VARCHAR2(3)
RULE_SET_NAME VARCHAR2(30)
RULE_SET_OWNER VARCHAR2(30)
APPLY_USER VARCHAR2(30)
APPLY_DATABASE_LINK VARCHAR2(128)
APPLY_TAG RAW(2000)
DDL_HANDLER VARCHAR2(98)
PRECOMMIT_HANDLER VARCHAR2(98)
MESSAGE_HANDLER VARCHAR2(98)
STATUS VARCHAR2(8)
MAX_APPLIED_MESSAGE_NUMBER NUMBER
NEGATIVE_RULE_SET_NAME VARCHAR2(30)
NEGATIVE_RULE_SET_OWNER VARCHAR2(30)
STATUS_CHANGE_TIME DATE
ERROR_NUMBER NUMBER
ERROR_MESSAGE VARCHAR2(4000)
SQL> desc dba_apply_parameters;
Name Null? Type
----------------------------------------- --------
----------------------------
APPLY_NAME NOT NULL VARCHAR2(30)
PARAMETER NOT NULL VARCHAR2(128)
VALUE VARCHAR2(4000)
SET_BY_USER VARCHAR2(3)
SQL> desc dba_apply_table_columns;
Name Null? Type
----------------------------------------- --------
----------------------------
OBJECT_OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(30)
COLUMN_NAME VARCHAR2(4000)
COMPARE_OLD_ON_DELETE VARCHAR2(3)
COMPARE_OLD_ON_UPDATE VARCHAR2(3)
APPLY_DATABASE_LINK VARCHAR2(128)
SQL> desc dba_associations;
Name Null? Type
----------------------------------------- --------
----------------------------
OBJECT_OWNER NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME VARCHAR2(30)
OBJECT_TYPE VARCHAR2(9)
STATSTYPE_SCHEMA VARCHAR2(30)
STATSTYPE_NAME VARCHAR2(30)
DEF_SELECTIVITY NUMBER
DEF_CPU_COST NUMBER
DEF_IO_COST NUMBER
DEF_NET_COST NUMBER
INTERFACE_VERSION NUMBER
SQL> desc dba_blockers;
Name Null? Type
----------------------------------------- --------
----------------------------
HOLDING_SESSION NUMBER
SQL> desc dba_capture
Name Null? Type
----------------------------------------- --------
----------------------------
CAPTURE_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)
CAPTURE_USER VARCHAR2(30)
START_SCN NUMBER
STATUS VARCHAR2(8)
CAPTURED_SCN NUMBER
APPLIED_SCN NUMBER
USE_DATABASE_LINK VARCHAR2(3)
FIRST_SCN NUMBER
SOURCE_DATABASE VARCHAR2(128)
SOURCE_DBID NUMBER
SOURCE_RESETLOGS_SCN NUMBER
SOURCE_RESETLOGS_TIME NUMBER
LOGMINER_ID NUMBER
NEGATIVE_RULE_SET_NAME VARCHAR2(30)
NEGATIVE_RULE_SET_OWNER VARCHAR2(30)
MAX_CHECKPOINT_SCN NUMBER
REQUIRED_CHECKPOINT_SCN NUMBER
LOGFILE_ASSIGNMENT VARCHAR2(8)
STATUS_CHANGE_TIME DATE
ERROR_NUMBER NUMBER
ERROR_MESSAGE VARCHAR2(4000)
VERSION VARCHAR2(64)
CAPTURE_TYPE VARCHAR2(10)
LAST_ENQUEUED_SCN NUMBER
CHECKPOINT_RETENTION_TIME NUMBER
SQL> desc dba_catalog;
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
SQL> desc dba_clusters;
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
CLUSTER_NAME NOT NULL VARCHAR2(30)
TABLESPACE_NAME NOT NULL VARCHAR2(30)
PCT_FREE NUMBER
PCT_USED NUMBER
KEY_SIZE NUMBER
INI_TRANS NOT NULL NUMBER
MAX_TRANS NOT NULL NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NOT NULL NUMBER
MAX_EXTENTS NOT NULL NUMBER
PCT_INCREASE NUMBER
FREELISTS NUMBER
FREELIST_GROUPS NUMBER
AVG_BLOCKS_PER_KEY NUMBER
CLUSTER_TYPE VARCHAR2(5)
FUNCTION VARCHAR2(15)
HASHKEYS NUMBER
DEGREE VARCHAR2(10)
INSTANCES VARCHAR2(10)
CACHE VARCHAR2(5)
BUFFER_POOL VARCHAR2(7)
SINGLE_TABLE VARCHAR2(5)
DEPENDENCIES VARCHAR2(8)
SQL> desc dba_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)
SQL> desc dba_col_privs;
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)
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_context
Name Null? Type
----------------------------------------- --------
----------------------------
NAMESPACE NOT NULL VARCHAR2(30)
SCHEMA NOT NULL VARCHAR2(30)
PACKAGE NOT NULL VARCHAR2(30)
TYPE VARCHAR2(22)
SQL> desc dba_data_files
Name Null? Type
----------------------------------------- --------
----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
ONLINE_STATUS VARCHAR2(7)
SQL> desc dba_datapump_jobs;
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER_NAME VARCHAR2(30)
JOB_NAME VARCHAR2(30)
OPERATION VARCHAR2(30)
JOB_MODE VARCHAR2(30)
STATE VARCHAR2(30)
DEGREE NUMBER
ATTACHED_SESSIONS NUMBER
DATAPUMP_SESSIONS NUMBER
SQL> desc dba_datapump_sessions;
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER_NAME VARCHAR2(30)
JOB_NAME VARCHAR2(30)
SADDR RAW(4)
SESSION_TYPE VARCHAR2(14)
SQL> desc dba_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
SQL> desc dba_ddl_locks
Name Null? Type
----------------------------------------- --------
----------------------------
SESSION_ID NUMBER
OWNER VARCHAR2(30)
NAME VARCHAR2(30)
TYPE VARCHAR2(40)
MODE_HELD VARCHAR2(9)
MODE_REQUESTED VARCHAR2(9)
SQL> desc dba_directories;
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
DIRECTORY_NAME NOT NULL VARCHAR2(30)
DIRECTORY_PATH VARCHAR2(4000)
SQL> desc dba_dml_locks;
Name Null? Type
----------------------------------------- --------
----------------------------
SESSION_ID NUMBER
OWNER NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(30)
MODE_HELD VARCHAR2(13)
MODE_REQUESTED VARCHAR2(13)
LAST_CONVERT NUMBER
BLOCKING_OTHERS VARCHAR2(40)
SQL> desc dba_dmt_free_space
Name Null? Type
----------------------------------------- --------
----------------------------
TABLESPACE_ID NOT NULL NUMBER
FILE_ID NOT NULL NUMBER
BLOCK_ID NOT NULL NUMBER
BLOCKS NOT NULL NUMBER
SQL> desc dba_dmt_used_extents
Name Null? Type
----------------------------------------- --------
----------------------------
SEGMENT_FILEID NOT NULL NUMBER
SEGMENT_BLOCK NOT NULL NUMBER
TABLESPACE_ID NOT NULL NUMBER
EXTENT_ID NOT NULL NUMBER
FILEID NOT NULL NUMBER
BLOCK NOT NULL NUMBER
LENGTH NOT NULL NUMBER
SQL> desc dba_enabled_aggregations
Name Null? Type
----------------------------------------- --------
----------------------------
AGGREGATION_TYPE VARCHAR2(21)
PRIMARY_ID VARCHAR2(64)
QUALIFIER_ID1 VARCHAR2(48)
QUALIFIER_ID2 VARCHAR2(32)
SQL> desc dba_enabled_traces
Name Null? Type
----------------------------------------- --------
----------------------------
TRACE_TYPE VARCHAR2(21)
PRIMARY_ID VARCHAR2(64)
QUALIFIER_ID1 VARCHAR2(48)
QUALIFIER_ID2 VARCHAR2(32)
WAITS VARCHAR2(5)
BINDS VARCHAR2(5)
INSTANCE_NAME VARCHAR2(16)
SQL> desc dba_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
SQL> desc dba_exp_files
Name Null? Type
----------------------------------------- --------
----------------------------
EXP_VERSION NOT NULL NUMBER(3)
EXP_TYPE VARCHAR2(11)
FILE_NAME NOT NULL VARCHAR2(100)
USER_NAME NOT NULL VARCHAR2(30)
TIMESTAMP NOT NULL DATE
SQL> desc dba_exp_objects
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
OBJECT_TYPE VARCHAR2(13)
CUMULATIVE DATE
INCREMENTAL NOT NULL DATE
EXPORT_VERSION NOT NULL NUMBER(3)
SQL> desc dba_exp_version
Name Null? Type
----------------------------------------- --------
----------------------------
EXP_VERSION NOT NULL NUMBER(3)
SQL> desc dba_extents
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
SEGMENT_NAME VARCHAR2(81)
PARTITION_NAME VARCHAR2(30)
SEGMENT_TYPE VARCHAR2(18)
TABLESPACE_NAME VARCHAR2(30)
EXTENT_ID NUMBER
FILE_ID NUMBER
BLOCK_ID NUMBER
BYTES NUMBER
BLOCKS NUMBER
RELATIVE_FNO NUMBER
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_feature_usage_statistics
Name Null? Type
----------------------------------------- --------
----------------------------
DBID NOT NULL NUMBER
NAME NOT NULL VARCHAR2(64)
VERSION NOT NULL VARCHAR2(17)
DETECTED_USAGES NOT NULL NUMBER
TOTAL_SAMPLES NOT NULL NUMBER
CURRENTLY_USED VARCHAR2(5)
FIRST_USAGE_DATE DATE
LAST_USAGE_DATE DATE
AUX_COUNT NUMBER
FEATURE_INFO CLOB
LAST_SAMPLE_DATE DATE
LAST_SAMPLE_PERIOD NUMBER
SAMPLE_INTERVAL NUMBER
DESCRIPTION VARCHAR2(128)
SQL> desc dba_free_space
Name Null? Type
----------------------------------------- --------
----------------------------
TABLESPACE_NAME VARCHAR2(30)
FILE_ID NUMBER
BLOCK_ID NUMBER
BYTES NUMBER
BLOCKS NUMBER
RELATIVE_FNO NUMBER
SQL> desc dba_free_space_coalesced
Name Null? Type
----------------------------------------- --------
----------------------------
TABLESPACE_NAME VARCHAR2(30)
TOTAL_EXTENTS NUMBER
EXTENTS_COALESCED NUMBER
PERCENT_EXTENTS_COALESCED NUMBER
TOTAL_BYTES NUMBER
BYTES_COALESCED NUMBER
TOTAL_BLOCKS NUMBER
BLOCKS_COALESCED NUMBER
PERCENT_BLOCKS_COALESCED NUMBER
SQL> desc dba_high_water_mark_statistics
Name Null? Type
----------------------------------------- --------
----------------------------
DBID NOT NULL NUMBER
NAME NOT NULL VARCHAR2(64)
VERSION NOT NULL VARCHAR2(17)
HIGHWATER NUMBER
LAST_VALUE NUMBER
DESCRIPTION VARCHAR2(128)
SQL> desc dba_hist_baseline
Name Null? Type
----------------------------------------- --------
----------------------------
DBID NOT NULL NUMBER
BASELINE_ID NOT NULL NUMBER
BASELINE_NAME VARCHAR2(64)
START_SNAP_ID NUMBER
START_SNAP_TIME TIMESTAMP(3)
END_SNAP_ID NUMBER
END_SNAP_TIME TIMESTAMP(3)
SQL> desc dba_hist_buffer_pool_stat
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
ID NOT NULL NUMBER
NAME VARCHAR2(20)
BLOCK_SIZE NUMBER
SET_MSIZE NUMBER
CNUM_REPL NUMBER
CNUM_WRITE NUMBER
CNUM_SET NUMBER
BUF_GOT NUMBER
SUM_WRITE NUMBER
SUM_SCAN NUMBER
FREE_BUFFER_WAIT NUMBER
WRITE_COMPLETE_WAIT NUMBER
BUFFER_BUSY_WAIT NUMBER
FREE_BUFFER_INSPECTED NUMBER
DIRTY_BUFFERS_INSPECTED NUMBER
DB_BLOCK_CHANGE NUMBER
DB_BLOCK_GETS NUMBER
CONSISTENT_GETS NUMBER
PHYSICAL_READS NUMBER
PHYSICAL_WRITES NUMBER
SQL> desc dba_hist_current_block_server
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
PIN1 NUMBER
PIN10 NUMBER
PIN100 NUMBER
PIN1000 NUMBER
PIN10000 NUMBER
FLUSH1 NUMBER
FLUSH10 NUMBER
FLUSH100 NUMBER
FLUSH1000 NUMBER
FLUSH10000 NUMBER
WRITE1 NUMBER
WRITE10 NUMBER
WRITE100 NUMBER
WRITE1000 NUMBER
WRITE10000 NUMBER
SQL> desc dba_hist_database_instance
Name Null? Type
----------------------------------------- --------
----------------------------
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
STARTUP_TIME NOT NULL TIMESTAMP(3)
PARALLEL NOT NULL VARCHAR2(3)
VERSION NOT NULL VARCHAR2(17)
DB_NAME VARCHAR2(9)
INSTANCE_NAME VARCHAR2(16)
HOST_NAME VARCHAR2(64)
LAST_ASH_SAMPLE_ID NOT NULL NUMBER
SQL> desc dba_hist_datafile
Name Null? Type
----------------------------------------- --------
----------------------------
DBID NOT NULL NUMBER
FILE# NOT NULL NUMBER
CREATION_CHANGE# NOT NULL NUMBER
FILENAME NOT NULL VARCHAR2(513)
TS# NOT NULL NUMBER
TSNAME NOT NULL VARCHAR2(30)
BLOCK_SIZE NUMBER
SQL> desc dba_hist_instance_recovery
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
RECOVERY_ESTIMATED_IOS NUMBER
ACTUAL_REDO_BLKS NUMBER
TARGET_REDO_BLKS NUMBER
LOG_FILE_SIZE_REDO_BLKS NUMBER
LOG_CHKPT_TIMEOUT_REDO_BLKS NUMBER
LOG_CHKPT_INTERVAL_REDO_BLKS NUMBER
FAST_START_IO_TARGET_REDO_BLKS NUMBER
TARGET_MTTR NUMBER
ESTIMATED_MTTR NUMBER
CKPT_BLOCK_WRITES NUMBER
OPTIMAL_LOGFILE_SIZE NUMBER
ESTD_CLUSTER_AVAILABLE_TIME NUMBER
WRITES_MTTR NUMBER
WRITES_LOGFILE_SIZE NUMBER
WRITES_LOG_CHECKPOINT_SETTINGS NUMBER
WRITES_OTHER_SETTINGS NUMBER
WRITES_AUTOTUNE NUMBER
WRITES_FULL_THREAD_CKPT NUMBER
SQL> desc dba_hist_log
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
GROUP# NOT NULL NUMBER
THREAD# NOT NULL NUMBER
SEQUENCE# NOT NULL NUMBER
BYTES NUMBER
MEMBERS NUMBER
ARCHIVED VARCHAR2(3)
STATUS VARCHAR2(16)
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
SQL> desc dba_hist_parameter
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NUMBER
DBID NUMBER
INSTANCE_NUMBER NUMBER
PARAMETER_HASH NUMBER
PARAMETER_NAME VARCHAR2(64)
VALUE VARCHAR2(512)
ISDEFAULT VARCHAR2(9)
ISMODIFIED VARCHAR2(10)
SQL> desc dba_hist_sga
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
NAME NOT NULL VARCHAR2(64)
VALUE NOT NULL NUMBER
SQL> desc dba_hist_snapshot
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
STARTUP_TIME NOT NULL TIMESTAMP(3)
BEGIN_INTERVAL_TIME NOT NULL TIMESTAMP(3)
END_INTERVAL_TIME NOT NULL TIMESTAMP(3)
FLUSH_ELAPSED INTERVAL DAY(5) TO
SECOND(1)
SNAP_LEVEL NUMBER
ERROR_COUNT NUMBER
SQL> desc dba_hist_tablespace_stat
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NUMBER
DBID NUMBER
INSTANCE_NUMBER NUMBER
TS# NUMBER
TSNAME VARCHAR2(30)
CONTENTS VARCHAR2(9)
STATUS VARCHAR2(9)
SEGMENT_SPACE_MANAGEMENT VARCHAR2(6)
EXTENT_MANAGEMENT VARCHAR2(10)
IS_BACKUP VARCHAR2(5)
SQL> desc dba_hist_tempfile
Name Null? Type
----------------------------------------- --------
----------------------------
DBID NOT NULL NUMBER
FILE# NOT NULL NUMBER
CREATION_CHANGE# NOT NULL NUMBER
FILENAME NOT NULL VARCHAR2(513)
TS# NOT NULL NUMBER
TSNAME NOT NULL VARCHAR2(30)
BLOCK_SIZE NUMBER
SQL> desc dba_hist_tbspc_space_usage
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NUMBER
DBID NOT NULL NUMBER
TABLESPACE_ID NUMBER
TABLESPACE_SIZE NUMBER
TABLESPACE_MAXSIZE NUMBER
TABLESPACE_USEDSIZE NUMBER
RTIME VARCHAR2(25)
SQL> desc dba_hist_thread
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
THREAD# NOT NULL NUMBER
THREAD_INSTANCE_NUMBER NUMBER
STATUS VARCHAR2(6)
OPEN_TIME DATE
CURRENT_GROUP# NUMBER
SEQUENCE# NUMBER
SQL> desc dba_hist_undostat
Name Null? Type
----------------------------------------- --------
----------------------------
BEGIN_TIME NOT NULL DATE
END_TIME NOT NULL DATE
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
SNAP_ID NOT NULL NUMBER
UNDOTSN NOT NULL NUMBER
UNDOBLKS NUMBER
TXNCOUNT NUMBER
MAXQUERYLEN NUMBER
MAXQUERYSQLID VARCHAR2(13)
MAXCONCURRENCY NUMBER
UNXPSTEALCNT NUMBER
UNXPBLKRELCNT NUMBER
UNXPBLKREUCNT NUMBER
EXPSTEALCNT NUMBER
EXPBLKRELCNT NUMBER
EXPBLKREUCNT NUMBER
SSOLDERRCNT NUMBER
NOSPACEERRCNT NUMBER
ACTIVEBLKS NUMBER
UNEXPIREDBLKS NUMBER
EXPIREDBLKS NUMBER
TUNED_UNDORETENTION NUMBER
SQL> desc dba_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)
SQL> desc dba_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
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_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 VARCHAR2(11)
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)
SQL> desc dba_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
SQL> desc dba_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)
SQL> desc dba_jobs_running
Name Null? Type
----------------------------------------- --------
----------------------------
SID NUMBER
JOB NUMBER
FAILURES NUMBER
LAST_DATE DATE
LAST_SEC VARCHAR2(8)
THIS_DATE DATE
THIS_SEC VARCHAR2(8)
INSTANCE NUMBER
SQL> desc dba_join_ind_columns
Name Null? Type
----------------------------------------- --------
----------------------------
INDEX_OWNER NOT NULL VARCHAR2(30)
INDEX_NAME NOT NULL VARCHAR2(30)
INNER_TABLE_OWNER NOT NULL VARCHAR2(30)
INNER_TABLE_NAME NOT NULL VARCHAR2(30)
INNER_TABLE_COLUMN NOT NULL VARCHAR2(30)
OUTER_TABLE_OWNER NOT NULL VARCHAR2(30)
OUTER_TABLE_NAME NOT NULL VARCHAR2(30)
OUTER_TABLE_COLUMN NOT NULL VARCHAR2(30)
SQL> desc dba_libraries
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
LIBRARY_NAME NOT NULL VARCHAR2(30)
FILE_SPEC VARCHAR2(2000)
DYNAMIC VARCHAR2(1)
STATUS VARCHAR2(7)
SQL> desc dba_kgllock
Name Null? Type
----------------------------------------- --------
----------------------------
KGLLKUSE RAW(4)
KGLLKHDL RAW(4)
KGLLKMOD NUMBER
KGLLKREQ NUMBER
KGLLKTYPE VARCHAR2(4)
SQL> desc dba_lmt_free_space
Name Null? Type
----------------------------------------- --------
----------------------------
TABLESPACE_ID NUMBER
FILE_ID NUMBER
BLOCK_ID NUMBER
BLOCKS NUMBER
SQL> desc dba_lmt_used_extents
Name Null? Type
----------------------------------------- --------
----------------------------
SEGMENT_FILEID NUMBER
SEGMENT_BLOCK NUMBER
TABLESPACE_ID NUMBER
EXTENT_ID NUMBER
FILEID NUMBER
BLOCK NUMBER
LENGTH NUMBER
SQL> desc dba_lock
Name Null? Type
----------------------------------------- --------
----------------------------
SESSION_ID NUMBER
LOCK_TYPE VARCHAR2(26)
MODE_HELD VARCHAR2(40)
MODE_REQUESTED VARCHAR2(40)
LOCK_ID1 VARCHAR2(40)
LOCK_ID2 VARCHAR2(40)
LAST_CONVERT NUMBER
BLOCKING_OTHERS VARCHAR2(40)
SQL> desc dba_locks
Name Null? Type
----------------------------------------- --------
----------------------------
SESSION_ID NUMBER
LOCK_TYPE VARCHAR2(26)
MODE_HELD VARCHAR2(40)
MODE_REQUESTED VARCHAR2(40)
LOCK_ID1 VARCHAR2(40)
LOCK_ID2 VARCHAR2(40)
LAST_CONVERT NUMBER
BLOCKING_OTHERS VARCHAR2(40)
SQL> desc dba_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
SQL> desc dba_mview_comments
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
MVIEW_NAME NOT NULL VARCHAR2(30)
COMMENTS VARCHAR2(4000)
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_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
SQL> desc dba_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
SQL> desc dba_nested_tables
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
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)
SQL> desc dba_object_size
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(30)
TYPE VARCHAR2(13)
SOURCE_SIZE NUMBER
PARSED_SIZE NUMBER
CODE_SIZE NUMBER
ERROR_SIZE NUMBER
SQL> desc dba_object_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)
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)
SQL> desc dba_objects
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
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)
SQL> desc dba_operators
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
OPERATOR_NAME NOT NULL VARCHAR2(30)
NUMBER_OF_BINDS NOT NULL NUMBER
SQL> desc dba_part_indexes
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
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)
SQL> desc dba_part_tables
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
TABLE_NAME VARCHAR2(30)
PARTITIONING_TYPE VARCHAR2(7)
SUBPARTITIONING_TYPE VARCHAR2(7)
PARTITION_COUNT NUMBER
DEF_SUBPARTITION_COUNT NUMBER
PARTITIONING_KEY_COUNT NUMBER
SUBPARTITIONING_KEY_COUNT NUMBER
STATUS VARCHAR2(8)
DEF_TABLESPACE_NAME VARCHAR2(30)
DEF_PCT_FREE NUMBER
DEF_PCT_USED NUMBER
DEF_INI_TRANS NUMBER
DEF_MAX_TRANS 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 NUMBER
DEF_FREELIST_GROUPS NUMBER
DEF_LOGGING VARCHAR2(7)
DEF_COMPRESSION VARCHAR2(8)
DEF_BUFFER_POOL VARCHAR2(7)
SQL> desc dba_partial_drop_tabs
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
SQL> desc dba_pending_transactions
Name Null? Type
----------------------------------------- --------
----------------------------
FORMATID NUMBER
GLOBALID RAW(64)
BRANCHID RAW(64)
SQL> desc dba_procedures
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
PROCEDURE_NAME VARCHAR2(30)
AGGREGATE VARCHAR2(3)
PIPELINED VARCHAR2(3)
IMPLTYPEOWNER VARCHAR2(30)
IMPLTYPENAME VARCHAR2(30)
PARALLEL VARCHAR2(3)
INTERFACE VARCHAR2(3)
DETERMINISTIC VARCHAR2(3)
AUTHID VARCHAR2(12)
SQL> desc dba_profiles
Name Null? Type
----------------------------------------- --------
----------------------------
PROFILE NOT NULL VARCHAR2(30)
RESOURCE_NAME NOT NULL VARCHAR2(32)
RESOURCE_TYPE VARCHAR2(8)
LIMIT VARCHAR2(40)
SQL> desc dba_queue_tables
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
QUEUE_TABLE VARCHAR2(30)
TYPE VARCHAR2(7)
OBJECT_TYPE VARCHAR2(61)
SORT_ORDER VARCHAR2(22)
RECIPIENTS VARCHAR2(8)
MESSAGE_GROUPING VARCHAR2(13)
COMPATIBLE VARCHAR2(6)
PRIMARY_INSTANCE NUMBER
SECONDARY_INSTANCE NUMBER
OWNER_INSTANCE NUMBER
USER_COMMENT VARCHAR2(50)
SECURE VARCHAR2(3)
SQL> desc dba_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)
SQL> desc dba_recyclebin
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
ORIGINAL_NAME VARCHAR2(32)
OPERATION VARCHAR2(9)
TYPE VARCHAR2(25)
TS_NAME VARCHAR2(30)
CREATETIME VARCHAR2(19)
DROPTIME VARCHAR2(19)
DROPSCN NUMBER
PARTITION_NAME VARCHAR2(32)
CAN_UNDROP VARCHAR2(3)
CAN_PURGE VARCHAR2(3)
RELATED NOT NULL NUMBER
BASE_OBJECT NOT NULL NUMBER
PURGE_OBJECT NOT NULL NUMBER
SPACE NUMBER
SQL> desc dba_refresh
Name Null? Type
----------------------------------------- --------
----------------------------
ROWNER NOT NULL VARCHAR2(30)
RNAME NOT NULL VARCHAR2(30)
REFGROUP NUMBER
IMPLICIT_DESTROY VARCHAR2(1)
PUSH_DEFERRED_RPC VARCHAR2(1)
REFRESH_AFTER_ERRORS VARCHAR2(1)
ROLLBACK_SEG VARCHAR2(30)
JOB NUMBER
NEXT_DATE DATE
INTERVAL VARCHAR2(200)
BROKEN VARCHAR2(1)
PURGE_OPTION NUMBER(38)
PARALLELISM NUMBER(38)
HEAP_SIZE NUMBER(38)
SQL> desc dba_registered_archived_log
Name Null? Type
----------------------------------------- --------
----------------------------
CONSUMER_NAME NOT NULL VARCHAR2(30)
SOURCE_DATABASE VARCHAR2(128)
THREAD# NOT NULL NUMBER
SEQUENCE# NOT NULL NUMBER
FIRST_SCN NOT NULL NUMBER
NEXT_SCN NUMBER
FIRST_TIME DATE
NEXT_TIME DATE
NAME VARCHAR2(513)
MODIFIED_TIME DATE
DICTIONARY_BEGIN VARCHAR2(3)
DICTIONARY_END VARCHAR2(3)
PURGEABLE VARCHAR2(3)
RESETLOGS_CHANGE# NOT NULL NUMBER
RESET_TIMESTAMP NOT NULL NUMBER
SQL> desc dba_registered_mview_groups
Name Null? Type
----------------------------------------- --------
----------------------------
NAME VARCHAR2(30)
MVIEW_SITE VARCHAR2(128)
GROUP_COMMENT VARCHAR2(80)
VERSION VARCHAR2(8)
FNAME VARCHAR2(30)
OWNER VARCHAR2(30)
SQL> desc dba_registered_mviews
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(30)
MVIEW_SITE NOT NULL VARCHAR2(128)
CAN_USE_LOG VARCHAR2(3)
UPDATABLE VARCHAR2(3)
REFRESH_METHOD VARCHAR2(11)
MVIEW_ID NUMBER(38)
VERSION VARCHAR2(26)
QUERY_TXT LONG
SQL> desc dba_registry
Name Null? Type
----------------------------------------- --------
----------------------------
COMP_ID NOT NULL VARCHAR2(30)
COMP_NAME VARCHAR2(255)
VERSION VARCHAR2(30)
STATUS VARCHAR2(11)
MODIFIED VARCHAR2(20)
NAMESPACE NOT NULL VARCHAR2(30)
CONTROL NOT NULL VARCHAR2(30)
SCHEMA NOT NULL VARCHAR2(30)
PROCEDURE VARCHAR2(61)
STARTUP VARCHAR2(8)
PARENT_ID VARCHAR2(30)
OTHER_SCHEMAS VARCHAR2(4000)
SQL> desc dba_repair_table
ERROR:
ORA-04043: object dba_repair_table does not exist
SQL> desc dba_role_privs
Name Null? Type
----------------------------------------- --------
----------------------------
GRANTEE VARCHAR2(30)
GRANTED_ROLE NOT NULL VARCHAR2(30)
ADMIN_OPTION VARCHAR2(3)
DEFAULT_ROLE VARCHAR2(3)
SQL> desc dba_roles
Name Null? Type
----------------------------------------- --------
----------------------------
ROLE NOT NULL VARCHAR2(30)
PASSWORD_REQUIRED VARCHAR2(8)
SQL> desc dba_rollback_segs
Name Null? Type
----------------------------------------- --------
----------------------------
SEGMENT_NAME NOT NULL VARCHAR2(30)
OWNER VARCHAR2(6)
TABLESPACE_NAME NOT NULL VARCHAR2(30)
SEGMENT_ID NOT NULL NUMBER
FILE_ID NOT NULL NUMBER
BLOCK_ID NOT NULL NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NOT NULL NUMBER
MAX_EXTENTS NOT NULL NUMBER
PCT_INCREASE NUMBER
STATUS VARCHAR2(16)
INSTANCE_NUM VARCHAR2(40)
RELATIVE_FNO NOT NULL NUMBER
SQL> desc dba_rules
Name Null? Type
----------------------------------------- --------
----------------------------
RULE_OWNER NOT NULL VARCHAR2(30)
RULE_NAME NOT NULL VARCHAR2(30)
RULE_CONDITION CLOB
RULE_EVALUATION_CONTEXT_OWNER VARCHAR2(30)
RULE_EVALUATION_CONTEXT_NAME VARCHAR2(30)
RULE_ACTION_CONTEXT RE$NV_LIST
RULE_COMMENT VARCHAR2(4000)
SQL> desc dba_scheduler_jobs
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
JOB_NAME NOT NULL VARCHAR2(30)
JOB_SUBNAME VARCHAR2(30)
JOB_CREATOR VARCHAR2(30)
CLIENT_ID VARCHAR2(64)
GLOBAL_UID VARCHAR2(32)
PROGRAM_OWNER VARCHAR2(4000)
PROGRAM_NAME VARCHAR2(4000)
JOB_TYPE VARCHAR2(16)
JOB_ACTION VARCHAR2(4000)
NUMBER_OF_ARGUMENTS NUMBER
SCHEDULE_OWNER VARCHAR2(4000)
SCHEDULE_NAME VARCHAR2(4000)
SCHEDULE_TYPE VARCHAR2(12)
START_DATE TIMESTAMP(6) WITH TIME
ZONE
REPEAT_INTERVAL VARCHAR2(4000)
EVENT_QUEUE_OWNER VARCHAR2(30)
EVENT_QUEUE_NAME VARCHAR2(30)
EVENT_QUEUE_AGENT VARCHAR2(30)
EVENT_CONDITION VARCHAR2(4000)
EVENT_RULE VARCHAR2(65)
END_DATE TIMESTAMP(6) WITH TIME
ZONE
JOB_CLASS VARCHAR2(30)
ENABLED VARCHAR2(5)
AUTO_DROP VARCHAR2(5)
RESTARTABLE VARCHAR2(5)
STATE VARCHAR2(15)
JOB_PRIORITY NUMBER
RUN_COUNT NUMBER
MAX_RUNS NUMBER
FAILURE_COUNT NUMBER
MAX_FAILURES NUMBER
RETRY_COUNT NUMBER
LAST_START_DATE TIMESTAMP(6) WITH TIME
ZONE
LAST_RUN_DURATION INTERVAL DAY(9) TO
SECOND(6)
NEXT_RUN_DATE TIMESTAMP(6) WITH TIME
ZONE
SCHEDULE_LIMIT INTERVAL DAY(3) TO
SECOND(0)
MAX_RUN_DURATION INTERVAL DAY(3) TO
SECOND(0)
LOGGING_LEVEL VARCHAR2(4)
STOP_ON_WINDOW_CLOSE VARCHAR2(5)
INSTANCE_STICKINESS VARCHAR2(5)
RAISE_EVENTS VARCHAR2(4000)
SYSTEM VARCHAR2(5)
JOB_WEIGHT NUMBER
NLS_ENV VARCHAR2(4000)
SOURCE VARCHAR2(128)
DESTINATION VARCHAR2(128)
COMMENTS VARCHAR2(240)
FLAGS NUMBER
SQL> desc dba_scheduler_schedules
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
SCHEDULE_NAME NOT NULL VARCHAR2(30)
SCHEDULE_TYPE VARCHAR2(8)
START_DATE TIMESTAMP(6) WITH TIME
ZONE
REPEAT_INTERVAL VARCHAR2(4000)
EVENT_QUEUE_OWNER VARCHAR2(30)
EVENT_QUEUE_NAME VARCHAR2(30)
EVENT_QUEUE_AGENT VARCHAR2(30)
EVENT_CONDITION VARCHAR2(4000)
END_DATE TIMESTAMP(6) WITH TIME
ZONE
COMMENTS VARCHAR2(240)
SQL> desc dba_segments
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
SEGMENT_NAME VARCHAR2(81)
PARTITION_NAME VARCHAR2(30)
SEGMENT_TYPE VARCHAR2(18)
TABLESPACE_NAME VARCHAR2(30)
HEADER_FILE NUMBER
HEADER_BLOCK NUMBER
BYTES NUMBER
BLOCKS NUMBER
EXTENTS NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NUMBER
MAX_EXTENTS NUMBER
PCT_INCREASE NUMBER
FREELISTS NUMBER
FREELIST_GROUPS NUMBER
RELATIVE_FNO NUMBER
BUFFER_POOL VARCHAR2(7)
SQL> desc dba_sequences
Name Null? Type
----------------------------------------- --------
----------------------------
SEQUENCE_OWNER NOT NULL VARCHAR2(30)
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
SQL> desc dba_server_registry
Name Null? Type
----------------------------------------- --------
----------------------------
COMP_ID NOT NULL VARCHAR2(30)
COMP_NAME VARCHAR2(255)
VERSION VARCHAR2(30)
STATUS VARCHAR2(11)
MODIFIED VARCHAR2(20)
CONTROL NOT NULL VARCHAR2(30)
SCHEMA NOT NULL VARCHAR2(30)
PROCEDURE VARCHAR2(61)
STARTUP VARCHAR2(8)
PARENT_ID VARCHAR2(30)
OTHER_SCHEMAS VARCHAR2(4000)
SQL> desc dba_services
Name Null? Type
----------------------------------------- --------
----------------------------
SERVICE_ID NUMBER
NAME VARCHAR2(64)
NAME_HASH NUMBER
NETWORK_NAME VARCHAR2(512)
CREATION_DATE DATE
CREATION_DATE_HASH NUMBER
FAILOVER_METHOD VARCHAR2(64)
FAILOVER_TYPE VARCHAR2(64)
FAILOVER_RETRIES NUMBER(10)
FAILOVER_DELAY NUMBER(10)
MIN_CARDINALITY NUMBER
MAX_CARDINALITY NUMBER
GOAL VARCHAR2(12)
DTP VARCHAR2(1)
ENABLED VARCHAR2(3)
AQ_HA_NOTIFICATIONS VARCHAR2(3)
CLB_GOAL VARCHAR2(5)
SQL> desc dba_source
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
NAME VARCHAR2(30)
TYPE VARCHAR2(12)
LINE NUMBER
TEXT VARCHAR2(4000)
SQL> desc dba_source_tables
Name Null? Type
----------------------------------------- --------
----------------------------
SOURCE_SCHEMA_NAME NOT NULL VARCHAR2(30)
SOURCE_TABLE_NAME NOT NULL VARCHAR2(30)
SQL> desc dba_sql_profiles
Name Null? Type
----------------------------------------- --------
----------------------------
NAME NOT NULL VARCHAR2(30)
CATEGORY NOT NULL VARCHAR2(30)
SIGNATURE NOT NULL NUMBER
SQL_TEXT NOT NULL CLOB
CREATED NOT NULL DATE
LAST_MODIFIED NOT NULL DATE
DESCRIPTION VARCHAR2(500)
TYPE VARCHAR2(9)
STATUS VARCHAR2(8)
FORCE_MATCHING VARCHAR2(3)
SQL> desc dba_streams_administrator
Name Null? Type
----------------------------------------- --------
----------------------------
USERNAME NOT NULL VARCHAR2(30)
LOCAL_PRIVILEGES VARCHAR2(3)
ACCESS_FROM_REMOTE VARCHAR2(3)
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_synonyms
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
SYNONYM_NAME NOT NULL VARCHAR2(30)
TABLE_OWNER VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
DB_LINK VARCHAR2(128)
SQL> desc dba_sys_privs
Name Null? Type
----------------------------------------- --------
----------------------------
GRANTEE NOT NULL VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
ADMIN_OPTION VARCHAR2(3)
SQL> desc dba_tab_col_statistics
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
TABLE_NAME VARCHAR2(30)
COLUMN_NAME VARCHAR2(30)
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
GLOBAL_STATS VARCHAR2(3)
USER_STATS VARCHAR2(3)
AVG_COL_LEN NUMBER
HISTOGRAM VARCHAR2(15)
SQL> desc dba_tab_cols
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
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)
SQL> desc dba_tab_columns
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
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)
HISTOGRAM VARCHAR2(15)
SQL> desc dba_tab_comments
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
COMMENTS VARCHAR2(4000)
SQL> desc dba_tab_modifications
Name Null? Type
----------------------------------------- --------
----------------------------
TABLE_OWNER VARCHAR2(30)
TABLE_NAME VARCHAR2(30)
PARTITION_NAME VARCHAR2(30)
SUBPARTITION_NAME VARCHAR2(30)
INSERTS NUMBER
UPDATES NUMBER
DELETES NUMBER
TIMESTAMP DATE
TRUNCATED VARCHAR2(3)
DROP_SEGMENTS NUMBER
SQL> desc dba_tab_partitions
Name Null? Type
----------------------------------------- --------
----------------------------
TABLE_OWNER VARCHAR2(30)
TABLE_NAME VARCHAR2(30)
COMPOSITE VARCHAR2(3)
PARTITION_NAME VARCHAR2(30)
SUBPARTITION_COUNT NUMBER
HIGH_VALUE LONG
HIGH_VALUE_LENGTH NUMBER
PARTITION_POSITION NUMBER
TABLESPACE_NAME VARCHAR2(30)
PCT_FREE NUMBER
PCT_USED 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)
NUM_ROWS NUMBER
BLOCKS NUMBER
EMPTY_BLOCKS NUMBER
AVG_SPACE NUMBER
CHAIN_CNT NUMBER
AVG_ROW_LEN NUMBER
SAMPLE_SIZE NUMBER
LAST_ANALYZED DATE
BUFFER_POOL VARCHAR2(7)
GLOBAL_STATS VARCHAR2(3)
USER_STATS VARCHAR2(3)
SQL> desc dba_tab_privs
Name Null? Type
----------------------------------------- --------
----------------------------
GRANTEE NOT NULL VARCHAR2(30)
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
GRANTOR NOT NULL VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
GRANTABLE VARCHAR2(3)
HIERARCHY VARCHAR2(3)
SQL> desc dba_tab_statistics
Name Null? Type
----------------------------------------- --------
----------------------------
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)
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
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)
SQL> desc dba_tab_subpartitions
Name Null? Type
----------------------------------------- --------
----------------------------
TABLE_OWNER NOT NULL VARCHAR2(30)
TABLE_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
TABLESPACE_NAME NOT NULL VARCHAR2(30)
PCT_FREE NOT NULL NUMBER
PCT_USED 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)
NUM_ROWS NUMBER
BLOCKS NUMBER
EMPTY_BLOCKS NUMBER
AVG_SPACE NUMBER
CHAIN_CNT NUMBER
AVG_ROW_LEN NUMBER
SAMPLE_SIZE NUMBER
LAST_ANALYZED DATE
BUFFER_POOL VARCHAR2(7)
GLOBAL_STATS VARCHAR2(3)
USER_STATS VARCHAR2(3)
SQL> desc dba_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)
SQL> desc dba_tablespace_groups
Name Null? Type
----------------------------------------- --------
----------------------------
GROUP_NAME NOT NULL VARCHAR2(30)
TABLESPACE_NAME NOT NULL VARCHAR2(30)
SQL> desc dba_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)
PLUGGED_IN VARCHAR2(3)
SEGMENT_SPACE_MANAGEMENT VARCHAR2(6)
DEF_TAB_COMPRESSION VARCHAR2(8)
RETENTION VARCHAR2(11)
BIGFILE VARCHAR2(3)
SQL> desc dba_temp_files
Name Null? Type
----------------------------------------- --------
----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME NOT NULL VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS CHAR(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
SQL> desc dba_thresholds
Name Null? Type
----------------------------------------- --------
----------------------------
METRICS_NAME VARCHAR2(64)
WARNING_OPERATOR VARCHAR2(12)
WARNING_VALUE VARCHAR2(256)
CRITICAL_OPERATOR VARCHAR2(12)
CRITICAL_VALUE VARCHAR2(256)
OBSERVATION_PERIOD NUMBER
CONSECUTIVE_OCCURRENCES NUMBER
INSTANCE_NAME VARCHAR2(16)
OBJECT_TYPE VARCHAR2(64)
OBJECT_NAME VARCHAR2(513)
STATUS VARCHAR2(7)
SQL> desc dba_transformations
Name Null? Type
----------------------------------------- --------
----------------------------
TRANSFORMATION_ID NOT NULL NUMBER
OWNER NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(30)
FROM_TYPE VARCHAR2(61)
TO_TYPE VARCHAR2(91)
SQL> desc dba_trigger_cols
Name Null? Type
----------------------------------------- --------
----------------------------
TRIGGER_OWNER VARCHAR2(30)
TRIGGER_NAME VARCHAR2(30)
TABLE_OWNER VARCHAR2(30)
TABLE_NAME VARCHAR2(30)
COLUMN_NAME VARCHAR2(4000)
COLUMN_LIST VARCHAR2(3)
COLUMN_USAGE VARCHAR2(17)
SQL> desc dba_triggers
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
TRIGGER_NAME VARCHAR2(30)
TRIGGER_TYPE VARCHAR2(16)
TRIGGERING_EVENT VARCHAR2(227)
TABLE_OWNER VARCHAR2(30)
BASE_OBJECT_TYPE VARCHAR2(16)
TABLE_NAME VARCHAR2(30)
COLUMN_NAME VARCHAR2(4000)
REFERENCING_NAMES VARCHAR2(128)
WHEN_CLAUSE VARCHAR2(4000)
STATUS VARCHAR2(8)
DESCRIPTION VARCHAR2(4000)
ACTION_TYPE VARCHAR2(11)
TRIGGER_BODY LONG
SQL> desc dba_ts_quotas
Name Null? Type
----------------------------------------- --------
----------------------------
TABLESPACE_NAME NOT NULL VARCHAR2(30)
USERNAME NOT NULL VARCHAR2(30)
BYTES NUMBER
MAX_BYTES NUMBER
BLOCKS NUMBER
MAX_BLOCKS NUMBER
DROPPED VARCHAR2(3)
SQL> desc dba_tune_mview
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
TASK_NAME VARCHAR2(30)
ACTION_ID NOT NULL NUMBER
SCRIPT_TYPE VARCHAR2(14)
STATEMENT CLOB
SQL> desc dba_type_attrs
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
TYPE_NAME VARCHAR2(30)
ATTR_NAME VARCHAR2(30)
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 NUMBER
INHERITED VARCHAR2(3)
SQL> desc dba_type_methods
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
TYPE_NAME NOT NULL VARCHAR2(30)
METHOD_NAME NOT NULL VARCHAR2(30)
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)
SQL> desc dba_type_versions
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
TYPE_NAME NOT NULL VARCHAR2(30)
VERSION# NOT NULL NUMBER
TYPECODE VARCHAR2(30)
STATUS VARCHAR2(7)
LINE NOT NULL NUMBER
TEXT VARCHAR2(4000)
HASHCODE RAW(17)
SQL> desc dba_types
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
TYPE_NAME VARCHAR2(30)
TYPE_OID RAW(16)
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
TYPEID RAW(16)
SQL> desc dba_undo_extents
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER CHAR(3)
SEGMENT_NAME NOT NULL VARCHAR2(30)
TABLESPACE_NAME NOT NULL VARCHAR2(30)
EXTENT_ID NUMBER
FILE_ID NOT NULL NUMBER
BLOCK_ID NUMBER
BYTES NUMBER
BLOCKS NUMBER
RELATIVE_FNO NUMBER
COMMIT_JTIME NUMBER
COMMIT_WTIME VARCHAR2(20)
STATUS VARCHAR2(9)
SQL> desc dba_users
Name Null? Type
----------------------------------------- --------
----------------------------
USERNAME NOT NULL VARCHAR2(30)
USER_ID NOT NULL NUMBER
PASSWORD VARCHAR2(30)
ACCOUNT_STATUS NOT NULL VARCHAR2(32)
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30)
CREATED NOT NULL DATE
PROFILE NOT NULL VARCHAR2(30)
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30)
EXTERNAL_NAME VARCHAR2(4000)
SQL> desc dba_views
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
VIEW_NAME NOT NULL VARCHAR2(30)
TEXT_LENGTH NUMBER
TEXT LONG
TYPE_TEXT_LENGTH NUMBER
TYPE_TEXT VARCHAR2(4000)
OID_TEXT_LENGTH NUMBER
OID_TEXT VARCHAR2(4000)
VIEW_TYPE_OWNER VARCHAR2(30)
VIEW_TYPE VARCHAR2(30)
SUPERVIEW_NAME VARCHAR2(30)
SQL> desc dbms_alert_info
Name Null? Type
----------------------------------------- --------
----------------------------
NAME NOT NULL VARCHAR2(30)
SID NOT NULL VARCHAR2(30)
CHANGED VARCHAR2(1)
MESSAGE VARCHAR2(1800)
SQL> desc dbms_lock_allocated
Name Null? Type
----------------------------------------- --------
----------------------------
NAME NOT NULL VARCHAR2(128)
LOCKID NUMBER(38)
EXPIRATION DATE
SQL> desc dictionary
Name Null? Type
----------------------------------------- --------
----------------------------
TABLE_NAME VARCHAR2(30)
COMMENTS VARCHAR2(4000)
SQL> desc dict_columns
Name Null? Type
----------------------------------------- --------
----------------------------
TABLE_NAME VARCHAR2(30)
COLUMN_NAME VARCHAR2(30)
COMMENTS VARCHAR2(4000)
SQL> desc dict
Name Null? Type
----------------------------------------- --------
----------------------------
TABLE_NAME VARCHAR2(30)
COMMENTS VARCHAR2(4000)
SQL> desc error_size
Name Null? Type
----------------------------------------- --------
----------------------------
OBJ# NOT NULL NUMBER
BYTES NUMBER
SQL> desc exceptions
ERROR:
ORA-04043: object exceptions does not exist
SQL> desc flashback_transaction_query
Name Null? Type
----------------------------------------- --------
----------------------------
XID RAW(8)
START_SCN NUMBER
START_TIMESTAMP DATE
COMMIT_SCN NUMBER
COMMIT_TIMESTAMP DATE
LOGON_USER VARCHAR2(30)
UNDO_CHANGE# NUMBER
OPERATION VARCHAR2(32)
TABLE_NAME VARCHAR2(256)
TABLE_OWNER VARCHAR2(32)
ROW_ID VARCHAR2(19)
UNDO_SQL VARCHAR2(4000)
SQL> desc global_name
Name Null? Type
----------------------------------------- --------
----------------------------
GLOBAL_NAME VARCHAR2(4000)
SQL> desc ind
Name Null? Type
----------------------------------------- --------
----------------------------
INDEX_NAME NOT NULL VARCHAR2(30)
INDEX_TYPE VARCHAR2(27)
TABLE_OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
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)
SQL> desc index_histogram
Name Null? Type
----------------------------------------- --------
----------------------------
REPEAT_COUNT NUMBER
KEYS_WITH_REPEAT_COUNT NUMBER
SQL> desc index_stats
Name Null? Type
----------------------------------------- --------
----------------------------
HEIGHT NUMBER
BLOCKS NUMBER
NAME VARCHAR2(30)
PARTITION_NAME VARCHAR2(30)
LF_ROWS NUMBER
LF_BLKS NUMBER
LF_ROWS_LEN NUMBER
LF_BLK_LEN NUMBER
BR_ROWS NUMBER
BR_BLKS NUMBER
BR_ROWS_LEN NUMBER
BR_BLK_LEN NUMBER
DEL_LF_ROWS NUMBER
DEL_LF_ROWS_LEN NUMBER
DISTINCT_KEYS NUMBER
MOST_REPEATED_KEY NUMBER
BTREE_SPACE NUMBER
USED_SPACE NUMBER
PCT_USED NUMBER
ROWS_PER_KEY NUMBER
BLKS_GETS_PER_ACCESS NUMBER
PRE_ROWS NUMBER
PRE_ROWS_LEN NUMBER
OPT_CMPR_COUNT NUMBER
OPT_CMPR_PCTSAVE NUMBER
SQL> desc map_object
Name Null? Type
----------------------------------------- --------
----------------------------
OBJECT_NAME VARCHAR2(2000)
OBJECT_OWNER VARCHAR2(2000)
OBJECT_TYPE VARCHAR2(2000)
FILE_MAP_IDX NUMBER
DEPTH NUMBER
ELEM_IDX NUMBER
CU_SIZE NUMBER
STRIDE NUMBER
NUM_CU NUMBER
ELEM_OFFSET NUMBER
FILE_OFFSET NUMBER
DATA_TYPE VARCHAR2(2000)
PARITY_POS NUMBER
PARITY_PERIOD NUMBER
SQL> desc nls_database_parameters
Name Null? Type
----------------------------------------- --------
----------------------------
PARAMETER NOT NULL VARCHAR2(30)
VALUE VARCHAR2(40)
SQL> desc nls_instance_parameters
Name Null? Type
----------------------------------------- --------
----------------------------
PARAMETER VARCHAR2(30)
VALUE VARCHAR2(40)
SQL> desc nls_session_parameters
Name Null? Type
----------------------------------------- --------
----------------------------
PARAMETER VARCHAR2(30)
VALUE VARCHAR2(40)
SQL> desc obj
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)
SQL> desc plan_table
Name Null? Type
----------------------------------------- --------
----------------------------
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 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
OTHER_XML CLOB
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)
SQL> desc queue_privileges
Name Null? Type
----------------------------------------- --------
----------------------------
GRANTEE NOT NULL VARCHAR2(30)
OWNER NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(30)
GRANTOR NOT NULL VARCHAR2(30)
ENQUEUE_PRIVILEGE NUMBER
DEQUEUE_PRIVILEGE NUMBER
SQL> desc recyclebin
Name Null? Type
----------------------------------------- --------
----------------------------
OBJECT_NAME NOT NULL VARCHAR2(30)
ORIGINAL_NAME VARCHAR2(32)
OPERATION VARCHAR2(9)
TYPE VARCHAR2(25)
TS_NAME VARCHAR2(30)
CREATETIME VARCHAR2(19)
DROPTIME VARCHAR2(19)
DROPSCN NUMBER
PARTITION_NAME VARCHAR2(32)
CAN_UNDROP VARCHAR2(3)
CAN_PURGE VARCHAR2(3)
RELATED NOT NULL NUMBER
BASE_OBJECT NOT NULL NUMBER
PURGE_OBJECT NOT NULL NUMBER
SPACE NUMBER
SQL> desc role_role_privs
Name Null? Type
----------------------------------------- --------
----------------------------
ROLE NOT NULL VARCHAR2(30)
GRANTED_ROLE NOT NULL VARCHAR2(30)
ADMIN_OPTION VARCHAR2(3)
SQL> desc role_sys_privs
Name Null? Type
----------------------------------------- --------
----------------------------
ROLE NOT NULL VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
ADMIN_OPTION VARCHAR2(3)
SQL> desc role_tab_privs
Name Null? Type
----------------------------------------- --------
----------------------------
ROLE NOT NULL VARCHAR2(30)
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
GRANTABLE VARCHAR2(3)
SQL> desc seq
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
SQL> desc session_context
Name Null? Type
----------------------------------------- --------
----------------------------
NAMESPACE VARCHAR2(30)
ATTRIBUTE VARCHAR2(30)
VALUE VARCHAR2(4000)
SQL> desc session_privs
Name Null? Type
----------------------------------------- --------
----------------------------
PRIVILEGE NOT NULL VARCHAR2(40)
SQL> desc session_roles
Name Null? Type
----------------------------------------- --------
----------------------------
ROLE NOT NULL VARCHAR2(30)
SQL> desc session_size
ERROR:
ORA-04043: object session_size does not exist
SQL> desc source_size
Name Null? Type
----------------------------------------- --------
----------------------------
OBJ# NOT NULL NUMBER
BYTES NUMBER
SQL> desc syn
Name Null? Type
----------------------------------------- --------
----------------------------
SYNONYM_NAME NOT NULL VARCHAR2(30)
TABLE_OWNER VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
DB_LINK VARCHAR2(128)
SQL> desc synonyms
Name Null? Type
----------------------------------------- --------
----------------------------
SNAME VARCHAR2(30)
SYNTYPE VARCHAR2(7)
CREATOR VARCHAR2(30)
TNAME VARCHAR2(30)
DATABASE VARCHAR2(128)
TABTYPE VARCHAR2(10)
SQL> desc sys_objects
Name Null? Type
----------------------------------------- --------
----------------------------
OBJECT_TYPE VARCHAR2(18)
OBJECT_TYPE_ID NUMBER
SEGMENT_TYPE_ID NUMBER
OBJECT_ID NUMBER
HEADER_FILE NUMBER
HEADER_BLOCK NUMBER
TS_NUMBER NUMBER
SQL> desc syscatalog
Name Null? Type
----------------------------------------- --------
----------------------------
TNAME NOT NULL VARCHAR2(30)
CREATOR NOT NULL VARCHAR2(30)
TABLETYPE VARCHAR2(8)
REMARKS VARCHAR2(4000)
SQL> desc sysfiles
Name Null? Type
----------------------------------------- --------
----------------------------
TSNAME NOT NULL VARCHAR2(30)
FNAME VARCHAR2(513)
BLOCKS NUMBER
SQL> desc system_privilege_map
Name Null? Type
----------------------------------------- --------
----------------------------
PRIVILEGE NOT NULL NUMBER
NAME NOT NULL VARCHAR2(40)
PROPERTY NOT NULL NUMBER
SQL> desc tab
Name Null? Type
----------------------------------------- --------
----------------------------
TNAME NOT NULL VARCHAR2(30)
TABTYPE VARCHAR2(7)
CLUSTERID NUMBER
SQL> desc table_privilege_map
Name Null? Type
----------------------------------------- --------
----------------------------
PRIVILEGE NOT NULL NUMBER
NAME NOT NULL VARCHAR2(40)
SQL> desc tabquotas
Name Null? Type
----------------------------------------- --------
----------------------------
TNAME NOT NULL VARCHAR2(30)
TYPE VARCHAR2(7)
OBJNO NOT NULL NUMBER
NEXTEXT NUMBER
MAXEXT NOT NULL NUMBER
PINC NUMBER
PFREE NUMBER
PUSED NUMBER
SQL> desc tabs
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)
SQL> desc trusted_servers
Name Null? Type
----------------------------------------- --------
----------------------------
TRUST VARCHAR2(9)
NAME VARCHAR2(128)
SQL> spool off
SQL> desc dba_alert_history;
Name Null? Type
----------------------------------------- --------
----------------------------
SEQUENCE_ID NOT NULL NUMBER
REASON_ID NUMBER
OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(513)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_TYPE VARCHAR2(64)
REASON VARCHAR2(4000)
TIME_SUGGESTED TIMESTAMP(6) WITH TIME
ZONE
CREATION_TIME TIMESTAMP(6) WITH TIME
ZONE
SUGGESTED_ACTION VARCHAR2(4000)
ADVISOR_NAME VARCHAR2(30)
METRIC_VALUE NUMBER
MESSAGE_TYPE VARCHAR2(12)
MESSAGE_GROUP VARCHAR2(64)
MESSAGE_LEVEL NUMBER
HOSTING_CLIENT_ID VARCHAR2(64)
MODULE_ID VARCHAR2(64)
PROCESS_ID VARCHAR2(128)
HOST_ID VARCHAR2(256)
HOST_NW_ADDR VARCHAR2(256)
INSTANCE_NAME VARCHAR2(16)
INSTANCE_NUMBER NUMBER
USER_ID VARCHAR2(30)
EXECUTION_CONTEXT_ID VARCHAR2(60)
ERROR_INSTANCE_ID VARCHAR2(142)
RESOLUTION VARCHAR2(7)
SQL> desc dba_all_tables;
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
TABLE_NAME 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)
SQL> desc dba_application_roles;
Name Null? Type
----------------------------------------- --------
----------------------------
ROLE NOT NULL VARCHAR2(30)
SCHEMA NOT NULL VARCHAR2(30)
PACKAGE NOT NULL VARCHAR2(30)
SQL> desc dba_apply;
Name Null? Type
----------------------------------------- --------
----------------------------
APPLY_NAME NOT NULL VARCHAR2(30)
QUEUE_NAME NOT NULL VARCHAR2(30)
QUEUE_OWNER NOT NULL VARCHAR2(30)
APPLY_CAPTURED VARCHAR2(3)
RULE_SET_NAME VARCHAR2(30)
RULE_SET_OWNER VARCHAR2(30)
APPLY_USER VARCHAR2(30)
APPLY_DATABASE_LINK VARCHAR2(128)
APPLY_TAG RAW(2000)
DDL_HANDLER VARCHAR2(98)
PRECOMMIT_HANDLER VARCHAR2(98)
MESSAGE_HANDLER VARCHAR2(98)
STATUS VARCHAR2(8)
MAX_APPLIED_MESSAGE_NUMBER NUMBER
NEGATIVE_RULE_SET_NAME VARCHAR2(30)
NEGATIVE_RULE_SET_OWNER VARCHAR2(30)
STATUS_CHANGE_TIME DATE
ERROR_NUMBER NUMBER
ERROR_MESSAGE VARCHAR2(4000)
SQL> desc dba_apply_parameters;
Name Null? Type
----------------------------------------- --------
----------------------------
APPLY_NAME NOT NULL VARCHAR2(30)
PARAMETER NOT NULL VARCHAR2(128)
VALUE VARCHAR2(4000)
SET_BY_USER VARCHAR2(3)
SQL> desc dba_apply_table_columns;
Name Null? Type
----------------------------------------- --------
----------------------------
OBJECT_OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(30)
COLUMN_NAME VARCHAR2(4000)
COMPARE_OLD_ON_DELETE VARCHAR2(3)
COMPARE_OLD_ON_UPDATE VARCHAR2(3)
APPLY_DATABASE_LINK VARCHAR2(128)
SQL> desc dba_associations;
Name Null? Type
----------------------------------------- --------
----------------------------
OBJECT_OWNER NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME VARCHAR2(30)
OBJECT_TYPE VARCHAR2(9)
STATSTYPE_SCHEMA VARCHAR2(30)
STATSTYPE_NAME VARCHAR2(30)
DEF_SELECTIVITY NUMBER
DEF_CPU_COST NUMBER
DEF_IO_COST NUMBER
DEF_NET_COST NUMBER
INTERFACE_VERSION NUMBER
SQL> desc dba_blockers;
Name Null? Type
----------------------------------------- --------
----------------------------
HOLDING_SESSION NUMBER
SQL> desc dba_capture
Name Null? Type
----------------------------------------- --------
----------------------------
CAPTURE_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)
CAPTURE_USER VARCHAR2(30)
START_SCN NUMBER
STATUS VARCHAR2(8)
CAPTURED_SCN NUMBER
APPLIED_SCN NUMBER
USE_DATABASE_LINK VARCHAR2(3)
FIRST_SCN NUMBER
SOURCE_DATABASE VARCHAR2(128)
SOURCE_DBID NUMBER
SOURCE_RESETLOGS_SCN NUMBER
SOURCE_RESETLOGS_TIME NUMBER
LOGMINER_ID NUMBER
NEGATIVE_RULE_SET_NAME VARCHAR2(30)
NEGATIVE_RULE_SET_OWNER VARCHAR2(30)
MAX_CHECKPOINT_SCN NUMBER
REQUIRED_CHECKPOINT_SCN NUMBER
LOGFILE_ASSIGNMENT VARCHAR2(8)
STATUS_CHANGE_TIME DATE
ERROR_NUMBER NUMBER
ERROR_MESSAGE VARCHAR2(4000)
VERSION VARCHAR2(64)
CAPTURE_TYPE VARCHAR2(10)
LAST_ENQUEUED_SCN NUMBER
CHECKPOINT_RETENTION_TIME NUMBER
SQL> desc dba_catalog;
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
SQL> desc dba_clusters;
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
CLUSTER_NAME NOT NULL VARCHAR2(30)
TABLESPACE_NAME NOT NULL VARCHAR2(30)
PCT_FREE NUMBER
PCT_USED NUMBER
KEY_SIZE NUMBER
INI_TRANS NOT NULL NUMBER
MAX_TRANS NOT NULL NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NOT NULL NUMBER
MAX_EXTENTS NOT NULL NUMBER
PCT_INCREASE NUMBER
FREELISTS NUMBER
FREELIST_GROUPS NUMBER
AVG_BLOCKS_PER_KEY NUMBER
CLUSTER_TYPE VARCHAR2(5)
FUNCTION VARCHAR2(15)
HASHKEYS NUMBER
DEGREE VARCHAR2(10)
INSTANCES VARCHAR2(10)
CACHE VARCHAR2(5)
BUFFER_POOL VARCHAR2(7)
SINGLE_TABLE VARCHAR2(5)
DEPENDENCIES VARCHAR2(8)
SQL> desc dba_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)
SQL> desc dba_col_privs;
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)
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_context
Name Null? Type
----------------------------------------- --------
----------------------------
NAMESPACE NOT NULL VARCHAR2(30)
SCHEMA NOT NULL VARCHAR2(30)
PACKAGE NOT NULL VARCHAR2(30)
TYPE VARCHAR2(22)
SQL> desc dba_data_files
Name Null? Type
----------------------------------------- --------
----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
ONLINE_STATUS VARCHAR2(7)
SQL> desc dba_datapump_jobs;
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER_NAME VARCHAR2(30)
JOB_NAME VARCHAR2(30)
OPERATION VARCHAR2(30)
JOB_MODE VARCHAR2(30)
STATE VARCHAR2(30)
DEGREE NUMBER
ATTACHED_SESSIONS NUMBER
DATAPUMP_SESSIONS NUMBER
SQL> desc dba_datapump_sessions;
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER_NAME VARCHAR2(30)
JOB_NAME VARCHAR2(30)
SADDR RAW(4)
SESSION_TYPE VARCHAR2(14)
SQL> desc dba_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
SQL> desc dba_ddl_locks
Name Null? Type
----------------------------------------- --------
----------------------------
SESSION_ID NUMBER
OWNER VARCHAR2(30)
NAME VARCHAR2(30)
TYPE VARCHAR2(40)
MODE_HELD VARCHAR2(9)
MODE_REQUESTED VARCHAR2(9)
SQL> desc dba_directories;
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
DIRECTORY_NAME NOT NULL VARCHAR2(30)
DIRECTORY_PATH VARCHAR2(4000)
SQL> desc dba_dml_locks;
Name Null? Type
----------------------------------------- --------
----------------------------
SESSION_ID NUMBER
OWNER NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(30)
MODE_HELD VARCHAR2(13)
MODE_REQUESTED VARCHAR2(13)
LAST_CONVERT NUMBER
BLOCKING_OTHERS VARCHAR2(40)
SQL> desc dba_dmt_free_space
Name Null? Type
----------------------------------------- --------
----------------------------
TABLESPACE_ID NOT NULL NUMBER
FILE_ID NOT NULL NUMBER
BLOCK_ID NOT NULL NUMBER
BLOCKS NOT NULL NUMBER
SQL> desc dba_dmt_used_extents
Name Null? Type
----------------------------------------- --------
----------------------------
SEGMENT_FILEID NOT NULL NUMBER
SEGMENT_BLOCK NOT NULL NUMBER
TABLESPACE_ID NOT NULL NUMBER
EXTENT_ID NOT NULL NUMBER
FILEID NOT NULL NUMBER
BLOCK NOT NULL NUMBER
LENGTH NOT NULL NUMBER
SQL> desc dba_enabled_aggregations
Name Null? Type
----------------------------------------- --------
----------------------------
AGGREGATION_TYPE VARCHAR2(21)
PRIMARY_ID VARCHAR2(64)
QUALIFIER_ID1 VARCHAR2(48)
QUALIFIER_ID2 VARCHAR2(32)
SQL> desc dba_enabled_traces
Name Null? Type
----------------------------------------- --------
----------------------------
TRACE_TYPE VARCHAR2(21)
PRIMARY_ID VARCHAR2(64)
QUALIFIER_ID1 VARCHAR2(48)
QUALIFIER_ID2 VARCHAR2(32)
WAITS VARCHAR2(5)
BINDS VARCHAR2(5)
INSTANCE_NAME VARCHAR2(16)
SQL> desc dba_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
SQL> desc dba_exp_files
Name Null? Type
----------------------------------------- --------
----------------------------
EXP_VERSION NOT NULL NUMBER(3)
EXP_TYPE VARCHAR2(11)
FILE_NAME NOT NULL VARCHAR2(100)
USER_NAME NOT NULL VARCHAR2(30)
TIMESTAMP NOT NULL DATE
SQL> desc dba_exp_objects
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
OBJECT_TYPE VARCHAR2(13)
CUMULATIVE DATE
INCREMENTAL NOT NULL DATE
EXPORT_VERSION NOT NULL NUMBER(3)
SQL> desc dba_exp_version
Name Null? Type
----------------------------------------- --------
----------------------------
EXP_VERSION NOT NULL NUMBER(3)
SQL> desc dba_extents
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
SEGMENT_NAME VARCHAR2(81)
PARTITION_NAME VARCHAR2(30)
SEGMENT_TYPE VARCHAR2(18)
TABLESPACE_NAME VARCHAR2(30)
EXTENT_ID NUMBER
FILE_ID NUMBER
BLOCK_ID NUMBER
BYTES NUMBER
BLOCKS NUMBER
RELATIVE_FNO NUMBER
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_feature_usage_statistics
Name Null? Type
----------------------------------------- --------
----------------------------
DBID NOT NULL NUMBER
NAME NOT NULL VARCHAR2(64)
VERSION NOT NULL VARCHAR2(17)
DETECTED_USAGES NOT NULL NUMBER
TOTAL_SAMPLES NOT NULL NUMBER
CURRENTLY_USED VARCHAR2(5)
FIRST_USAGE_DATE DATE
LAST_USAGE_DATE DATE
AUX_COUNT NUMBER
FEATURE_INFO CLOB
LAST_SAMPLE_DATE DATE
LAST_SAMPLE_PERIOD NUMBER
SAMPLE_INTERVAL NUMBER
DESCRIPTION VARCHAR2(128)
SQL> desc dba_free_space
Name Null? Type
----------------------------------------- --------
----------------------------
TABLESPACE_NAME VARCHAR2(30)
FILE_ID NUMBER
BLOCK_ID NUMBER
BYTES NUMBER
BLOCKS NUMBER
RELATIVE_FNO NUMBER
SQL> desc dba_free_space_coalesced
Name Null? Type
----------------------------------------- --------
----------------------------
TABLESPACE_NAME VARCHAR2(30)
TOTAL_EXTENTS NUMBER
EXTENTS_COALESCED NUMBER
PERCENT_EXTENTS_COALESCED NUMBER
TOTAL_BYTES NUMBER
BYTES_COALESCED NUMBER
TOTAL_BLOCKS NUMBER
BLOCKS_COALESCED NUMBER
PERCENT_BLOCKS_COALESCED NUMBER
SQL> desc dba_high_water_mark_statistics
Name Null? Type
----------------------------------------- --------
----------------------------
DBID NOT NULL NUMBER
NAME NOT NULL VARCHAR2(64)
VERSION NOT NULL VARCHAR2(17)
HIGHWATER NUMBER
LAST_VALUE NUMBER
DESCRIPTION VARCHAR2(128)
SQL> desc dba_hist_baseline
Name Null? Type
----------------------------------------- --------
----------------------------
DBID NOT NULL NUMBER
BASELINE_ID NOT NULL NUMBER
BASELINE_NAME VARCHAR2(64)
START_SNAP_ID NUMBER
START_SNAP_TIME TIMESTAMP(3)
END_SNAP_ID NUMBER
END_SNAP_TIME TIMESTAMP(3)
SQL> desc dba_hist_buffer_pool_stat
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
ID NOT NULL NUMBER
NAME VARCHAR2(20)
BLOCK_SIZE NUMBER
SET_MSIZE NUMBER
CNUM_REPL NUMBER
CNUM_WRITE NUMBER
CNUM_SET NUMBER
BUF_GOT NUMBER
SUM_WRITE NUMBER
SUM_SCAN NUMBER
FREE_BUFFER_WAIT NUMBER
WRITE_COMPLETE_WAIT NUMBER
BUFFER_BUSY_WAIT NUMBER
FREE_BUFFER_INSPECTED NUMBER
DIRTY_BUFFERS_INSPECTED NUMBER
DB_BLOCK_CHANGE NUMBER
DB_BLOCK_GETS NUMBER
CONSISTENT_GETS NUMBER
PHYSICAL_READS NUMBER
PHYSICAL_WRITES NUMBER
SQL> desc dba_hist_current_block_server
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
PIN1 NUMBER
PIN10 NUMBER
PIN100 NUMBER
PIN1000 NUMBER
PIN10000 NUMBER
FLUSH1 NUMBER
FLUSH10 NUMBER
FLUSH100 NUMBER
FLUSH1000 NUMBER
FLUSH10000 NUMBER
WRITE1 NUMBER
WRITE10 NUMBER
WRITE100 NUMBER
WRITE1000 NUMBER
WRITE10000 NUMBER
SQL> desc dba_hist_database_instance
Name Null? Type
----------------------------------------- --------
----------------------------
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
STARTUP_TIME NOT NULL TIMESTAMP(3)
PARALLEL NOT NULL VARCHAR2(3)
VERSION NOT NULL VARCHAR2(17)
DB_NAME VARCHAR2(9)
INSTANCE_NAME VARCHAR2(16)
HOST_NAME VARCHAR2(64)
LAST_ASH_SAMPLE_ID NOT NULL NUMBER
SQL> desc dba_hist_datafile
Name Null? Type
----------------------------------------- --------
----------------------------
DBID NOT NULL NUMBER
FILE# NOT NULL NUMBER
CREATION_CHANGE# NOT NULL NUMBER
FILENAME NOT NULL VARCHAR2(513)
TS# NOT NULL NUMBER
TSNAME NOT NULL VARCHAR2(30)
BLOCK_SIZE NUMBER
SQL> desc dba_hist_instance_recovery
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
RECOVERY_ESTIMATED_IOS NUMBER
ACTUAL_REDO_BLKS NUMBER
TARGET_REDO_BLKS NUMBER
LOG_FILE_SIZE_REDO_BLKS NUMBER
LOG_CHKPT_TIMEOUT_REDO_BLKS NUMBER
LOG_CHKPT_INTERVAL_REDO_BLKS NUMBER
FAST_START_IO_TARGET_REDO_BLKS NUMBER
TARGET_MTTR NUMBER
ESTIMATED_MTTR NUMBER
CKPT_BLOCK_WRITES NUMBER
OPTIMAL_LOGFILE_SIZE NUMBER
ESTD_CLUSTER_AVAILABLE_TIME NUMBER
WRITES_MTTR NUMBER
WRITES_LOGFILE_SIZE NUMBER
WRITES_LOG_CHECKPOINT_SETTINGS NUMBER
WRITES_OTHER_SETTINGS NUMBER
WRITES_AUTOTUNE NUMBER
WRITES_FULL_THREAD_CKPT NUMBER
SQL> desc dba_hist_log
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
GROUP# NOT NULL NUMBER
THREAD# NOT NULL NUMBER
SEQUENCE# NOT NULL NUMBER
BYTES NUMBER
MEMBERS NUMBER
ARCHIVED VARCHAR2(3)
STATUS VARCHAR2(16)
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
SQL> desc dba_hist_parameter
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NUMBER
DBID NUMBER
INSTANCE_NUMBER NUMBER
PARAMETER_HASH NUMBER
PARAMETER_NAME VARCHAR2(64)
VALUE VARCHAR2(512)
ISDEFAULT VARCHAR2(9)
ISMODIFIED VARCHAR2(10)
SQL> desc dba_hist_sga
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
NAME NOT NULL VARCHAR2(64)
VALUE NOT NULL NUMBER
SQL> desc dba_hist_snapshot
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
STARTUP_TIME NOT NULL TIMESTAMP(3)
BEGIN_INTERVAL_TIME NOT NULL TIMESTAMP(3)
END_INTERVAL_TIME NOT NULL TIMESTAMP(3)
FLUSH_ELAPSED INTERVAL DAY(5) TO
SECOND(1)
SNAP_LEVEL NUMBER
ERROR_COUNT NUMBER
SQL> desc dba_hist_tablespace_stat
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NUMBER
DBID NUMBER
INSTANCE_NUMBER NUMBER
TS# NUMBER
TSNAME VARCHAR2(30)
CONTENTS VARCHAR2(9)
STATUS VARCHAR2(9)
SEGMENT_SPACE_MANAGEMENT VARCHAR2(6)
EXTENT_MANAGEMENT VARCHAR2(10)
IS_BACKUP VARCHAR2(5)
SQL> desc dba_hist_tempfile
Name Null? Type
----------------------------------------- --------
----------------------------
DBID NOT NULL NUMBER
FILE# NOT NULL NUMBER
CREATION_CHANGE# NOT NULL NUMBER
FILENAME NOT NULL VARCHAR2(513)
TS# NOT NULL NUMBER
TSNAME NOT NULL VARCHAR2(30)
BLOCK_SIZE NUMBER
SQL> desc dba_hist_tbspc_space_usage
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NUMBER
DBID NOT NULL NUMBER
TABLESPACE_ID NUMBER
TABLESPACE_SIZE NUMBER
TABLESPACE_MAXSIZE NUMBER
TABLESPACE_USEDSIZE NUMBER
RTIME VARCHAR2(25)
SQL> desc dba_hist_thread
Name Null? Type
----------------------------------------- --------
----------------------------
SNAP_ID NOT NULL NUMBER
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
THREAD# NOT NULL NUMBER
THREAD_INSTANCE_NUMBER NUMBER
STATUS VARCHAR2(6)
OPEN_TIME DATE
CURRENT_GROUP# NUMBER
SEQUENCE# NUMBER
SQL> desc dba_hist_undostat
Name Null? Type
----------------------------------------- --------
----------------------------
BEGIN_TIME NOT NULL DATE
END_TIME NOT NULL DATE
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
SNAP_ID NOT NULL NUMBER
UNDOTSN NOT NULL NUMBER
UNDOBLKS NUMBER
TXNCOUNT NUMBER
MAXQUERYLEN NUMBER
MAXQUERYSQLID VARCHAR2(13)
MAXCONCURRENCY NUMBER
UNXPSTEALCNT NUMBER
UNXPBLKRELCNT NUMBER
UNXPBLKREUCNT NUMBER
EXPSTEALCNT NUMBER
EXPBLKRELCNT NUMBER
EXPBLKREUCNT NUMBER
SSOLDERRCNT NUMBER
NOSPACEERRCNT NUMBER
ACTIVEBLKS NUMBER
UNEXPIREDBLKS NUMBER
EXPIREDBLKS NUMBER
TUNED_UNDORETENTION NUMBER
SQL> desc dba_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)
SQL> desc dba_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
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_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 VARCHAR2(11)
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)
SQL> desc dba_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
SQL> desc dba_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)
SQL> desc dba_jobs_running
Name Null? Type
----------------------------------------- --------
----------------------------
SID NUMBER
JOB NUMBER
FAILURES NUMBER
LAST_DATE DATE
LAST_SEC VARCHAR2(8)
THIS_DATE DATE
THIS_SEC VARCHAR2(8)
INSTANCE NUMBER
SQL> desc dba_join_ind_columns
Name Null? Type
----------------------------------------- --------
----------------------------
INDEX_OWNER NOT NULL VARCHAR2(30)
INDEX_NAME NOT NULL VARCHAR2(30)
INNER_TABLE_OWNER NOT NULL VARCHAR2(30)
INNER_TABLE_NAME NOT NULL VARCHAR2(30)
INNER_TABLE_COLUMN NOT NULL VARCHAR2(30)
OUTER_TABLE_OWNER NOT NULL VARCHAR2(30)
OUTER_TABLE_NAME NOT NULL VARCHAR2(30)
OUTER_TABLE_COLUMN NOT NULL VARCHAR2(30)
SQL> desc dba_libraries
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
LIBRARY_NAME NOT NULL VARCHAR2(30)
FILE_SPEC VARCHAR2(2000)
DYNAMIC VARCHAR2(1)
STATUS VARCHAR2(7)
SQL> desc dba_kgllock
Name Null? Type
----------------------------------------- --------
----------------------------
KGLLKUSE RAW(4)
KGLLKHDL RAW(4)
KGLLKMOD NUMBER
KGLLKREQ NUMBER
KGLLKTYPE VARCHAR2(4)
SQL> desc dba_lmt_free_space
Name Null? Type
----------------------------------------- --------
----------------------------
TABLESPACE_ID NUMBER
FILE_ID NUMBER
BLOCK_ID NUMBER
BLOCKS NUMBER
SQL> desc dba_lmt_used_extents
Name Null? Type
----------------------------------------- --------
----------------------------
SEGMENT_FILEID NUMBER
SEGMENT_BLOCK NUMBER
TABLESPACE_ID NUMBER
EXTENT_ID NUMBER
FILEID NUMBER
BLOCK NUMBER
LENGTH NUMBER
SQL> desc dba_lock
Name Null? Type
----------------------------------------- --------
----------------------------
SESSION_ID NUMBER
LOCK_TYPE VARCHAR2(26)
MODE_HELD VARCHAR2(40)
MODE_REQUESTED VARCHAR2(40)
LOCK_ID1 VARCHAR2(40)
LOCK_ID2 VARCHAR2(40)
LAST_CONVERT NUMBER
BLOCKING_OTHERS VARCHAR2(40)
SQL> desc dba_locks
Name Null? Type
----------------------------------------- --------
----------------------------
SESSION_ID NUMBER
LOCK_TYPE VARCHAR2(26)
MODE_HELD VARCHAR2(40)
MODE_REQUESTED VARCHAR2(40)
LOCK_ID1 VARCHAR2(40)
LOCK_ID2 VARCHAR2(40)
LAST_CONVERT NUMBER
BLOCKING_OTHERS VARCHAR2(40)
SQL> desc dba_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
SQL> desc dba_mview_comments
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
MVIEW_NAME NOT NULL VARCHAR2(30)
COMMENTS VARCHAR2(4000)
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_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
SQL> desc dba_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
SQL> desc dba_nested_tables
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
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)
SQL> desc dba_object_size
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(30)
TYPE VARCHAR2(13)
SOURCE_SIZE NUMBER
PARSED_SIZE NUMBER
CODE_SIZE NUMBER
ERROR_SIZE NUMBER
SQL> desc dba_object_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)
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)
SQL> desc dba_objects
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
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)
SQL> desc dba_operators
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
OPERATOR_NAME NOT NULL VARCHAR2(30)
NUMBER_OF_BINDS NOT NULL NUMBER
SQL> desc dba_part_indexes
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
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)
SQL> desc dba_part_tables
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
TABLE_NAME VARCHAR2(30)
PARTITIONING_TYPE VARCHAR2(7)
SUBPARTITIONING_TYPE VARCHAR2(7)
PARTITION_COUNT NUMBER
DEF_SUBPARTITION_COUNT NUMBER
PARTITIONING_KEY_COUNT NUMBER
SUBPARTITIONING_KEY_COUNT NUMBER
STATUS VARCHAR2(8)
DEF_TABLESPACE_NAME VARCHAR2(30)
DEF_PCT_FREE NUMBER
DEF_PCT_USED NUMBER
DEF_INI_TRANS NUMBER
DEF_MAX_TRANS 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 NUMBER
DEF_FREELIST_GROUPS NUMBER
DEF_LOGGING VARCHAR2(7)
DEF_COMPRESSION VARCHAR2(8)
DEF_BUFFER_POOL VARCHAR2(7)
SQL> desc dba_partial_drop_tabs
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
SQL> desc dba_pending_transactions
Name Null? Type
----------------------------------------- --------
----------------------------
FORMATID NUMBER
GLOBALID RAW(64)
BRANCHID RAW(64)
SQL> desc dba_procedures
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
PROCEDURE_NAME VARCHAR2(30)
AGGREGATE VARCHAR2(3)
PIPELINED VARCHAR2(3)
IMPLTYPEOWNER VARCHAR2(30)
IMPLTYPENAME VARCHAR2(30)
PARALLEL VARCHAR2(3)
INTERFACE VARCHAR2(3)
DETERMINISTIC VARCHAR2(3)
AUTHID VARCHAR2(12)
SQL> desc dba_profiles
Name Null? Type
----------------------------------------- --------
----------------------------
PROFILE NOT NULL VARCHAR2(30)
RESOURCE_NAME NOT NULL VARCHAR2(32)
RESOURCE_TYPE VARCHAR2(8)
LIMIT VARCHAR2(40)
SQL> desc dba_queue_tables
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
QUEUE_TABLE VARCHAR2(30)
TYPE VARCHAR2(7)
OBJECT_TYPE VARCHAR2(61)
SORT_ORDER VARCHAR2(22)
RECIPIENTS VARCHAR2(8)
MESSAGE_GROUPING VARCHAR2(13)
COMPATIBLE VARCHAR2(6)
PRIMARY_INSTANCE NUMBER
SECONDARY_INSTANCE NUMBER
OWNER_INSTANCE NUMBER
USER_COMMENT VARCHAR2(50)
SECURE VARCHAR2(3)
SQL> desc dba_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)
SQL> desc dba_recyclebin
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
ORIGINAL_NAME VARCHAR2(32)
OPERATION VARCHAR2(9)
TYPE VARCHAR2(25)
TS_NAME VARCHAR2(30)
CREATETIME VARCHAR2(19)
DROPTIME VARCHAR2(19)
DROPSCN NUMBER
PARTITION_NAME VARCHAR2(32)
CAN_UNDROP VARCHAR2(3)
CAN_PURGE VARCHAR2(3)
RELATED NOT NULL NUMBER
BASE_OBJECT NOT NULL NUMBER
PURGE_OBJECT NOT NULL NUMBER
SPACE NUMBER
SQL> desc dba_refresh
Name Null? Type
----------------------------------------- --------
----------------------------
ROWNER NOT NULL VARCHAR2(30)
RNAME NOT NULL VARCHAR2(30)
REFGROUP NUMBER
IMPLICIT_DESTROY VARCHAR2(1)
PUSH_DEFERRED_RPC VARCHAR2(1)
REFRESH_AFTER_ERRORS VARCHAR2(1)
ROLLBACK_SEG VARCHAR2(30)
JOB NUMBER
NEXT_DATE DATE
INTERVAL VARCHAR2(200)
BROKEN VARCHAR2(1)
PURGE_OPTION NUMBER(38)
PARALLELISM NUMBER(38)
HEAP_SIZE NUMBER(38)
SQL> desc dba_registered_archived_log
Name Null? Type
----------------------------------------- --------
----------------------------
CONSUMER_NAME NOT NULL VARCHAR2(30)
SOURCE_DATABASE VARCHAR2(128)
THREAD# NOT NULL NUMBER
SEQUENCE# NOT NULL NUMBER
FIRST_SCN NOT NULL NUMBER
NEXT_SCN NUMBER
FIRST_TIME DATE
NEXT_TIME DATE
NAME VARCHAR2(513)
MODIFIED_TIME DATE
DICTIONARY_BEGIN VARCHAR2(3)
DICTIONARY_END VARCHAR2(3)
PURGEABLE VARCHAR2(3)
RESETLOGS_CHANGE# NOT NULL NUMBER
RESET_TIMESTAMP NOT NULL NUMBER
SQL> desc dba_registered_mview_groups
Name Null? Type
----------------------------------------- --------
----------------------------
NAME VARCHAR2(30)
MVIEW_SITE VARCHAR2(128)
GROUP_COMMENT VARCHAR2(80)
VERSION VARCHAR2(8)
FNAME VARCHAR2(30)
OWNER VARCHAR2(30)
SQL> desc dba_registered_mviews
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(30)
MVIEW_SITE NOT NULL VARCHAR2(128)
CAN_USE_LOG VARCHAR2(3)
UPDATABLE VARCHAR2(3)
REFRESH_METHOD VARCHAR2(11)
MVIEW_ID NUMBER(38)
VERSION VARCHAR2(26)
QUERY_TXT LONG
SQL> desc dba_registry
Name Null? Type
----------------------------------------- --------
----------------------------
COMP_ID NOT NULL VARCHAR2(30)
COMP_NAME VARCHAR2(255)
VERSION VARCHAR2(30)
STATUS VARCHAR2(11)
MODIFIED VARCHAR2(20)
NAMESPACE NOT NULL VARCHAR2(30)
CONTROL NOT NULL VARCHAR2(30)
SCHEMA NOT NULL VARCHAR2(30)
PROCEDURE VARCHAR2(61)
STARTUP VARCHAR2(8)
PARENT_ID VARCHAR2(30)
OTHER_SCHEMAS VARCHAR2(4000)
SQL> desc dba_repair_table
ERROR:
ORA-04043: object dba_repair_table does not exist
SQL> desc dba_role_privs
Name Null? Type
----------------------------------------- --------
----------------------------
GRANTEE VARCHAR2(30)
GRANTED_ROLE NOT NULL VARCHAR2(30)
ADMIN_OPTION VARCHAR2(3)
DEFAULT_ROLE VARCHAR2(3)
SQL> desc dba_roles
Name Null? Type
----------------------------------------- --------
----------------------------
ROLE NOT NULL VARCHAR2(30)
PASSWORD_REQUIRED VARCHAR2(8)
SQL> desc dba_rollback_segs
Name Null? Type
----------------------------------------- --------
----------------------------
SEGMENT_NAME NOT NULL VARCHAR2(30)
OWNER VARCHAR2(6)
TABLESPACE_NAME NOT NULL VARCHAR2(30)
SEGMENT_ID NOT NULL NUMBER
FILE_ID NOT NULL NUMBER
BLOCK_ID NOT NULL NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NOT NULL NUMBER
MAX_EXTENTS NOT NULL NUMBER
PCT_INCREASE NUMBER
STATUS VARCHAR2(16)
INSTANCE_NUM VARCHAR2(40)
RELATIVE_FNO NOT NULL NUMBER
SQL> desc dba_rules
Name Null? Type
----------------------------------------- --------
----------------------------
RULE_OWNER NOT NULL VARCHAR2(30)
RULE_NAME NOT NULL VARCHAR2(30)
RULE_CONDITION CLOB
RULE_EVALUATION_CONTEXT_OWNER VARCHAR2(30)
RULE_EVALUATION_CONTEXT_NAME VARCHAR2(30)
RULE_ACTION_CONTEXT RE$NV_LIST
RULE_COMMENT VARCHAR2(4000)
SQL> desc dba_scheduler_jobs
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
JOB_NAME NOT NULL VARCHAR2(30)
JOB_SUBNAME VARCHAR2(30)
JOB_CREATOR VARCHAR2(30)
CLIENT_ID VARCHAR2(64)
GLOBAL_UID VARCHAR2(32)
PROGRAM_OWNER VARCHAR2(4000)
PROGRAM_NAME VARCHAR2(4000)
JOB_TYPE VARCHAR2(16)
JOB_ACTION VARCHAR2(4000)
NUMBER_OF_ARGUMENTS NUMBER
SCHEDULE_OWNER VARCHAR2(4000)
SCHEDULE_NAME VARCHAR2(4000)
SCHEDULE_TYPE VARCHAR2(12)
START_DATE TIMESTAMP(6) WITH TIME
ZONE
REPEAT_INTERVAL VARCHAR2(4000)
EVENT_QUEUE_OWNER VARCHAR2(30)
EVENT_QUEUE_NAME VARCHAR2(30)
EVENT_QUEUE_AGENT VARCHAR2(30)
EVENT_CONDITION VARCHAR2(4000)
EVENT_RULE VARCHAR2(65)
END_DATE TIMESTAMP(6) WITH TIME
ZONE
JOB_CLASS VARCHAR2(30)
ENABLED VARCHAR2(5)
AUTO_DROP VARCHAR2(5)
RESTARTABLE VARCHAR2(5)
STATE VARCHAR2(15)
JOB_PRIORITY NUMBER
RUN_COUNT NUMBER
MAX_RUNS NUMBER
FAILURE_COUNT NUMBER
MAX_FAILURES NUMBER
RETRY_COUNT NUMBER
LAST_START_DATE TIMESTAMP(6) WITH TIME
ZONE
LAST_RUN_DURATION INTERVAL DAY(9) TO
SECOND(6)
NEXT_RUN_DATE TIMESTAMP(6) WITH TIME
ZONE
SCHEDULE_LIMIT INTERVAL DAY(3) TO
SECOND(0)
MAX_RUN_DURATION INTERVAL DAY(3) TO
SECOND(0)
LOGGING_LEVEL VARCHAR2(4)
STOP_ON_WINDOW_CLOSE VARCHAR2(5)
INSTANCE_STICKINESS VARCHAR2(5)
RAISE_EVENTS VARCHAR2(4000)
SYSTEM VARCHAR2(5)
JOB_WEIGHT NUMBER
NLS_ENV VARCHAR2(4000)
SOURCE VARCHAR2(128)
DESTINATION VARCHAR2(128)
COMMENTS VARCHAR2(240)
FLAGS NUMBER
SQL> desc dba_scheduler_schedules
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
SCHEDULE_NAME NOT NULL VARCHAR2(30)
SCHEDULE_TYPE VARCHAR2(8)
START_DATE TIMESTAMP(6) WITH TIME
ZONE
REPEAT_INTERVAL VARCHAR2(4000)
EVENT_QUEUE_OWNER VARCHAR2(30)
EVENT_QUEUE_NAME VARCHAR2(30)
EVENT_QUEUE_AGENT VARCHAR2(30)
EVENT_CONDITION VARCHAR2(4000)
END_DATE TIMESTAMP(6) WITH TIME
ZONE
COMMENTS VARCHAR2(240)
SQL> desc dba_segments
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
SEGMENT_NAME VARCHAR2(81)
PARTITION_NAME VARCHAR2(30)
SEGMENT_TYPE VARCHAR2(18)
TABLESPACE_NAME VARCHAR2(30)
HEADER_FILE NUMBER
HEADER_BLOCK NUMBER
BYTES NUMBER
BLOCKS NUMBER
EXTENTS NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NUMBER
MAX_EXTENTS NUMBER
PCT_INCREASE NUMBER
FREELISTS NUMBER
FREELIST_GROUPS NUMBER
RELATIVE_FNO NUMBER
BUFFER_POOL VARCHAR2(7)
SQL> desc dba_sequences
Name Null? Type
----------------------------------------- --------
----------------------------
SEQUENCE_OWNER NOT NULL VARCHAR2(30)
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
SQL> desc dba_server_registry
Name Null? Type
----------------------------------------- --------
----------------------------
COMP_ID NOT NULL VARCHAR2(30)
COMP_NAME VARCHAR2(255)
VERSION VARCHAR2(30)
STATUS VARCHAR2(11)
MODIFIED VARCHAR2(20)
CONTROL NOT NULL VARCHAR2(30)
SCHEMA NOT NULL VARCHAR2(30)
PROCEDURE VARCHAR2(61)
STARTUP VARCHAR2(8)
PARENT_ID VARCHAR2(30)
OTHER_SCHEMAS VARCHAR2(4000)
SQL> desc dba_services
Name Null? Type
----------------------------------------- --------
----------------------------
SERVICE_ID NUMBER
NAME VARCHAR2(64)
NAME_HASH NUMBER
NETWORK_NAME VARCHAR2(512)
CREATION_DATE DATE
CREATION_DATE_HASH NUMBER
FAILOVER_METHOD VARCHAR2(64)
FAILOVER_TYPE VARCHAR2(64)
FAILOVER_RETRIES NUMBER(10)
FAILOVER_DELAY NUMBER(10)
MIN_CARDINALITY NUMBER
MAX_CARDINALITY NUMBER
GOAL VARCHAR2(12)
DTP VARCHAR2(1)
ENABLED VARCHAR2(3)
AQ_HA_NOTIFICATIONS VARCHAR2(3)
CLB_GOAL VARCHAR2(5)
SQL> desc dba_source
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
NAME VARCHAR2(30)
TYPE VARCHAR2(12)
LINE NUMBER
TEXT VARCHAR2(4000)
SQL> desc dba_source_tables
Name Null? Type
----------------------------------------- --------
----------------------------
SOURCE_SCHEMA_NAME NOT NULL VARCHAR2(30)
SOURCE_TABLE_NAME NOT NULL VARCHAR2(30)
SQL> desc dba_sql_profiles
Name Null? Type
----------------------------------------- --------
----------------------------
NAME NOT NULL VARCHAR2(30)
CATEGORY NOT NULL VARCHAR2(30)
SIGNATURE NOT NULL NUMBER
SQL_TEXT NOT NULL CLOB
CREATED NOT NULL DATE
LAST_MODIFIED NOT NULL DATE
DESCRIPTION VARCHAR2(500)
TYPE VARCHAR2(9)
STATUS VARCHAR2(8)
FORCE_MATCHING VARCHAR2(3)
SQL> desc dba_streams_administrator
Name Null? Type
----------------------------------------- --------
----------------------------
USERNAME NOT NULL VARCHAR2(30)
LOCAL_PRIVILEGES VARCHAR2(3)
ACCESS_FROM_REMOTE VARCHAR2(3)
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_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)
SQL> desc dba_synonyms
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
SYNONYM_NAME NOT NULL VARCHAR2(30)
TABLE_OWNER VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
DB_LINK VARCHAR2(128)
SQL> desc dba_sys_privs
Name Null? Type
----------------------------------------- --------
----------------------------
GRANTEE NOT NULL VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
ADMIN_OPTION VARCHAR2(3)
SQL> desc dba_tab_col_statistics
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
TABLE_NAME VARCHAR2(30)
COLUMN_NAME VARCHAR2(30)
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
GLOBAL_STATS VARCHAR2(3)
USER_STATS VARCHAR2(3)
AVG_COL_LEN NUMBER
HISTOGRAM VARCHAR2(15)
SQL> desc dba_tab_cols
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
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)
SQL> desc dba_tab_columns
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
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)
HISTOGRAM VARCHAR2(15)
SQL> desc dba_tab_comments
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
COMMENTS VARCHAR2(4000)
SQL> desc dba_tab_modifications
Name Null? Type
----------------------------------------- --------
----------------------------
TABLE_OWNER VARCHAR2(30)
TABLE_NAME VARCHAR2(30)
PARTITION_NAME VARCHAR2(30)
SUBPARTITION_NAME VARCHAR2(30)
INSERTS NUMBER
UPDATES NUMBER
DELETES NUMBER
TIMESTAMP DATE
TRUNCATED VARCHAR2(3)
DROP_SEGMENTS NUMBER
SQL> desc dba_tab_partitions
Name Null? Type
----------------------------------------- --------
----------------------------
TABLE_OWNER VARCHAR2(30)
TABLE_NAME VARCHAR2(30)
COMPOSITE VARCHAR2(3)
PARTITION_NAME VARCHAR2(30)
SUBPARTITION_COUNT NUMBER
HIGH_VALUE LONG
HIGH_VALUE_LENGTH NUMBER
PARTITION_POSITION NUMBER
TABLESPACE_NAME VARCHAR2(30)
PCT_FREE NUMBER
PCT_USED 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)
NUM_ROWS NUMBER
BLOCKS NUMBER
EMPTY_BLOCKS NUMBER
AVG_SPACE NUMBER
CHAIN_CNT NUMBER
AVG_ROW_LEN NUMBER
SAMPLE_SIZE NUMBER
LAST_ANALYZED DATE
BUFFER_POOL VARCHAR2(7)
GLOBAL_STATS VARCHAR2(3)
USER_STATS VARCHAR2(3)
SQL> desc dba_tab_privs
Name Null? Type
----------------------------------------- --------
----------------------------
GRANTEE NOT NULL VARCHAR2(30)
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
GRANTOR NOT NULL VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
GRANTABLE VARCHAR2(3)
HIERARCHY VARCHAR2(3)
SQL> desc dba_tab_statistics
Name Null? Type
----------------------------------------- --------
----------------------------
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)
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
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)
SQL> desc dba_tab_subpartitions
Name Null? Type
----------------------------------------- --------
----------------------------
TABLE_OWNER NOT NULL VARCHAR2(30)
TABLE_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
TABLESPACE_NAME NOT NULL VARCHAR2(30)
PCT_FREE NOT NULL NUMBER
PCT_USED 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)
NUM_ROWS NUMBER
BLOCKS NUMBER
EMPTY_BLOCKS NUMBER
AVG_SPACE NUMBER
CHAIN_CNT NUMBER
AVG_ROW_LEN NUMBER
SAMPLE_SIZE NUMBER
LAST_ANALYZED DATE
BUFFER_POOL VARCHAR2(7)
GLOBAL_STATS VARCHAR2(3)
USER_STATS VARCHAR2(3)
SQL> desc dba_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)
SQL> desc dba_tablespace_groups
Name Null? Type
----------------------------------------- --------
----------------------------
GROUP_NAME NOT NULL VARCHAR2(30)
TABLESPACE_NAME NOT NULL VARCHAR2(30)
SQL> desc dba_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)
PLUGGED_IN VARCHAR2(3)
SEGMENT_SPACE_MANAGEMENT VARCHAR2(6)
DEF_TAB_COMPRESSION VARCHAR2(8)
RETENTION VARCHAR2(11)
BIGFILE VARCHAR2(3)
SQL> desc dba_temp_files
Name Null? Type
----------------------------------------- --------
----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME NOT NULL VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS CHAR(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
SQL> desc dba_thresholds
Name Null? Type
----------------------------------------- --------
----------------------------
METRICS_NAME VARCHAR2(64)
WARNING_OPERATOR VARCHAR2(12)
WARNING_VALUE VARCHAR2(256)
CRITICAL_OPERATOR VARCHAR2(12)
CRITICAL_VALUE VARCHAR2(256)
OBSERVATION_PERIOD NUMBER
CONSECUTIVE_OCCURRENCES NUMBER
INSTANCE_NAME VARCHAR2(16)
OBJECT_TYPE VARCHAR2(64)
OBJECT_NAME VARCHAR2(513)
STATUS VARCHAR2(7)
SQL> desc dba_transformations
Name Null? Type
----------------------------------------- --------
----------------------------
TRANSFORMATION_ID NOT NULL NUMBER
OWNER NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(30)
FROM_TYPE VARCHAR2(61)
TO_TYPE VARCHAR2(91)
SQL> desc dba_trigger_cols
Name Null? Type
----------------------------------------- --------
----------------------------
TRIGGER_OWNER VARCHAR2(30)
TRIGGER_NAME VARCHAR2(30)
TABLE_OWNER VARCHAR2(30)
TABLE_NAME VARCHAR2(30)
COLUMN_NAME VARCHAR2(4000)
COLUMN_LIST VARCHAR2(3)
COLUMN_USAGE VARCHAR2(17)
SQL> desc dba_triggers
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
TRIGGER_NAME VARCHAR2(30)
TRIGGER_TYPE VARCHAR2(16)
TRIGGERING_EVENT VARCHAR2(227)
TABLE_OWNER VARCHAR2(30)
BASE_OBJECT_TYPE VARCHAR2(16)
TABLE_NAME VARCHAR2(30)
COLUMN_NAME VARCHAR2(4000)
REFERENCING_NAMES VARCHAR2(128)
WHEN_CLAUSE VARCHAR2(4000)
STATUS VARCHAR2(8)
DESCRIPTION VARCHAR2(4000)
ACTION_TYPE VARCHAR2(11)
TRIGGER_BODY LONG
SQL> desc dba_ts_quotas
Name Null? Type
----------------------------------------- --------
----------------------------
TABLESPACE_NAME NOT NULL VARCHAR2(30)
USERNAME NOT NULL VARCHAR2(30)
BYTES NUMBER
MAX_BYTES NUMBER
BLOCKS NUMBER
MAX_BLOCKS NUMBER
DROPPED VARCHAR2(3)
SQL> desc dba_tune_mview
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
TASK_NAME VARCHAR2(30)
ACTION_ID NOT NULL NUMBER
SCRIPT_TYPE VARCHAR2(14)
STATEMENT CLOB
SQL> desc dba_type_attrs
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
TYPE_NAME VARCHAR2(30)
ATTR_NAME VARCHAR2(30)
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 NUMBER
INHERITED VARCHAR2(3)
SQL> desc dba_type_methods
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
TYPE_NAME NOT NULL VARCHAR2(30)
METHOD_NAME NOT NULL VARCHAR2(30)
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)
SQL> desc dba_type_versions
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
TYPE_NAME NOT NULL VARCHAR2(30)
VERSION# NOT NULL NUMBER
TYPECODE VARCHAR2(30)
STATUS VARCHAR2(7)
LINE NOT NULL NUMBER
TEXT VARCHAR2(4000)
HASHCODE RAW(17)
SQL> desc dba_types
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER VARCHAR2(30)
TYPE_NAME VARCHAR2(30)
TYPE_OID RAW(16)
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
TYPEID RAW(16)
SQL> desc dba_undo_extents
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER CHAR(3)
SEGMENT_NAME NOT NULL VARCHAR2(30)
TABLESPACE_NAME NOT NULL VARCHAR2(30)
EXTENT_ID NUMBER
FILE_ID NOT NULL NUMBER
BLOCK_ID NUMBER
BYTES NUMBER
BLOCKS NUMBER
RELATIVE_FNO NUMBER
COMMIT_JTIME NUMBER
COMMIT_WTIME VARCHAR2(20)
STATUS VARCHAR2(9)
SQL> desc dba_users
Name Null? Type
----------------------------------------- --------
----------------------------
USERNAME NOT NULL VARCHAR2(30)
USER_ID NOT NULL NUMBER
PASSWORD VARCHAR2(30)
ACCOUNT_STATUS NOT NULL VARCHAR2(32)
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30)
CREATED NOT NULL DATE
PROFILE NOT NULL VARCHAR2(30)
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30)
EXTERNAL_NAME VARCHAR2(4000)
SQL> desc dba_views
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
VIEW_NAME NOT NULL VARCHAR2(30)
TEXT_LENGTH NUMBER
TEXT LONG
TYPE_TEXT_LENGTH NUMBER
TYPE_TEXT VARCHAR2(4000)
OID_TEXT_LENGTH NUMBER
OID_TEXT VARCHAR2(4000)
VIEW_TYPE_OWNER VARCHAR2(30)
VIEW_TYPE VARCHAR2(30)
SUPERVIEW_NAME VARCHAR2(30)
SQL> desc dbms_alert_info
Name Null? Type
----------------------------------------- --------
----------------------------
NAME NOT NULL VARCHAR2(30)
SID NOT NULL VARCHAR2(30)
CHANGED VARCHAR2(1)
MESSAGE VARCHAR2(1800)
SQL> desc dbms_lock_allocated
Name Null? Type
----------------------------------------- --------
----------------------------
NAME NOT NULL VARCHAR2(128)
LOCKID NUMBER(38)
EXPIRATION DATE
SQL> desc dictionary
Name Null? Type
----------------------------------------- --------
----------------------------
TABLE_NAME VARCHAR2(30)
COMMENTS VARCHAR2(4000)
SQL> desc dict_columns
Name Null? Type
----------------------------------------- --------
----------------------------
TABLE_NAME VARCHAR2(30)
COLUMN_NAME VARCHAR2(30)
COMMENTS VARCHAR2(4000)
SQL> desc dict
Name Null? Type
----------------------------------------- --------
----------------------------
TABLE_NAME VARCHAR2(30)
COMMENTS VARCHAR2(4000)
SQL> desc error_size
Name Null? Type
----------------------------------------- --------
----------------------------
OBJ# NOT NULL NUMBER
BYTES NUMBER
SQL> desc exceptions
ERROR:
ORA-04043: object exceptions does not exist
SQL> desc flashback_transaction_query
Name Null? Type
----------------------------------------- --------
----------------------------
XID RAW(8)
START_SCN NUMBER
START_TIMESTAMP DATE
COMMIT_SCN NUMBER
COMMIT_TIMESTAMP DATE
LOGON_USER VARCHAR2(30)
UNDO_CHANGE# NUMBER
OPERATION VARCHAR2(32)
TABLE_NAME VARCHAR2(256)
TABLE_OWNER VARCHAR2(32)
ROW_ID VARCHAR2(19)
UNDO_SQL VARCHAR2(4000)
SQL> desc global_name
Name Null? Type
----------------------------------------- --------
----------------------------
GLOBAL_NAME VARCHAR2(4000)
SQL> desc ind
Name Null? Type
----------------------------------------- --------
----------------------------
INDEX_NAME NOT NULL VARCHAR2(30)
INDEX_TYPE VARCHAR2(27)
TABLE_OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
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)
SQL> desc index_histogram
Name Null? Type
----------------------------------------- --------
----------------------------
REPEAT_COUNT NUMBER
KEYS_WITH_REPEAT_COUNT NUMBER
SQL> desc index_stats
Name Null? Type
----------------------------------------- --------
----------------------------
HEIGHT NUMBER
BLOCKS NUMBER
NAME VARCHAR2(30)
PARTITION_NAME VARCHAR2(30)
LF_ROWS NUMBER
LF_BLKS NUMBER
LF_ROWS_LEN NUMBER
LF_BLK_LEN NUMBER
BR_ROWS NUMBER
BR_BLKS NUMBER
BR_ROWS_LEN NUMBER
BR_BLK_LEN NUMBER
DEL_LF_ROWS NUMBER
DEL_LF_ROWS_LEN NUMBER
DISTINCT_KEYS NUMBER
MOST_REPEATED_KEY NUMBER
BTREE_SPACE NUMBER
USED_SPACE NUMBER
PCT_USED NUMBER
ROWS_PER_KEY NUMBER
BLKS_GETS_PER_ACCESS NUMBER
PRE_ROWS NUMBER
PRE_ROWS_LEN NUMBER
OPT_CMPR_COUNT NUMBER
OPT_CMPR_PCTSAVE NUMBER
SQL> desc map_object
Name Null? Type
----------------------------------------- --------
----------------------------
OBJECT_NAME VARCHAR2(2000)
OBJECT_OWNER VARCHAR2(2000)
OBJECT_TYPE VARCHAR2(2000)
FILE_MAP_IDX NUMBER
DEPTH NUMBER
ELEM_IDX NUMBER
CU_SIZE NUMBER
STRIDE NUMBER
NUM_CU NUMBER
ELEM_OFFSET NUMBER
FILE_OFFSET NUMBER
DATA_TYPE VARCHAR2(2000)
PARITY_POS NUMBER
PARITY_PERIOD NUMBER
SQL> desc nls_database_parameters
Name Null? Type
----------------------------------------- --------
----------------------------
PARAMETER NOT NULL VARCHAR2(30)
VALUE VARCHAR2(40)
SQL> desc nls_instance_parameters
Name Null? Type
----------------------------------------- --------
----------------------------
PARAMETER VARCHAR2(30)
VALUE VARCHAR2(40)
SQL> desc nls_session_parameters
Name Null? Type
----------------------------------------- --------
----------------------------
PARAMETER VARCHAR2(30)
VALUE VARCHAR2(40)
SQL> desc obj
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)
SQL> desc plan_table
Name Null? Type
----------------------------------------- --------
----------------------------
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 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
OTHER_XML CLOB
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)
SQL> desc queue_privileges
Name Null? Type
----------------------------------------- --------
----------------------------
GRANTEE NOT NULL VARCHAR2(30)
OWNER NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(30)
GRANTOR NOT NULL VARCHAR2(30)
ENQUEUE_PRIVILEGE NUMBER
DEQUEUE_PRIVILEGE NUMBER
SQL> desc recyclebin
Name Null? Type
----------------------------------------- --------
----------------------------
OBJECT_NAME NOT NULL VARCHAR2(30)
ORIGINAL_NAME VARCHAR2(32)
OPERATION VARCHAR2(9)
TYPE VARCHAR2(25)
TS_NAME VARCHAR2(30)
CREATETIME VARCHAR2(19)
DROPTIME VARCHAR2(19)
DROPSCN NUMBER
PARTITION_NAME VARCHAR2(32)
CAN_UNDROP VARCHAR2(3)
CAN_PURGE VARCHAR2(3)
RELATED NOT NULL NUMBER
BASE_OBJECT NOT NULL NUMBER
PURGE_OBJECT NOT NULL NUMBER
SPACE NUMBER
SQL> desc role_role_privs
Name Null? Type
----------------------------------------- --------
----------------------------
ROLE NOT NULL VARCHAR2(30)
GRANTED_ROLE NOT NULL VARCHAR2(30)
ADMIN_OPTION VARCHAR2(3)
SQL> desc role_sys_privs
Name Null? Type
----------------------------------------- --------
----------------------------
ROLE NOT NULL VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
ADMIN_OPTION VARCHAR2(3)
SQL> desc role_tab_privs
Name Null? Type
----------------------------------------- --------
----------------------------
ROLE NOT NULL VARCHAR2(30)
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
GRANTABLE VARCHAR2(3)
SQL> desc seq
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
SQL> desc session_context
Name Null? Type
----------------------------------------- --------
----------------------------
NAMESPACE VARCHAR2(30)
ATTRIBUTE VARCHAR2(30)
VALUE VARCHAR2(4000)
SQL> desc session_privs
Name Null? Type
----------------------------------------- --------
----------------------------
PRIVILEGE NOT NULL VARCHAR2(40)
SQL> desc session_roles
Name Null? Type
----------------------------------------- --------
----------------------------
ROLE NOT NULL VARCHAR2(30)
SQL> desc session_size
ERROR:
ORA-04043: object session_size does not exist
SQL> desc source_size
Name Null? Type
----------------------------------------- --------
----------------------------
OBJ# NOT NULL NUMBER
BYTES NUMBER
SQL> desc syn
Name Null? Type
----------------------------------------- --------
----------------------------
SYNONYM_NAME NOT NULL VARCHAR2(30)
TABLE_OWNER VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
DB_LINK VARCHAR2(128)
SQL> desc synonyms
Name Null? Type
----------------------------------------- --------
----------------------------
SNAME VARCHAR2(30)
SYNTYPE VARCHAR2(7)
CREATOR VARCHAR2(30)
TNAME VARCHAR2(30)
DATABASE VARCHAR2(128)
TABTYPE VARCHAR2(10)
SQL> desc sys_objects
Name Null? Type
----------------------------------------- --------
----------------------------
OBJECT_TYPE VARCHAR2(18)
OBJECT_TYPE_ID NUMBER
SEGMENT_TYPE_ID NUMBER
OBJECT_ID NUMBER
HEADER_FILE NUMBER
HEADER_BLOCK NUMBER
TS_NUMBER NUMBER
SQL> desc syscatalog
Name Null? Type
----------------------------------------- --------
----------------------------
TNAME NOT NULL VARCHAR2(30)
CREATOR NOT NULL VARCHAR2(30)
TABLETYPE VARCHAR2(8)
REMARKS VARCHAR2(4000)
SQL> desc sysfiles
Name Null? Type
----------------------------------------- --------
----------------------------
TSNAME NOT NULL VARCHAR2(30)
FNAME VARCHAR2(513)
BLOCKS NUMBER
SQL> desc system_privilege_map
Name Null? Type
----------------------------------------- --------
----------------------------
PRIVILEGE NOT NULL NUMBER
NAME NOT NULL VARCHAR2(40)
PROPERTY NOT NULL NUMBER
SQL> desc tab
Name Null? Type
----------------------------------------- --------
----------------------------
TNAME NOT NULL VARCHAR2(30)
TABTYPE VARCHAR2(7)
CLUSTERID NUMBER
SQL> desc table_privilege_map
Name Null? Type
----------------------------------------- --------
----------------------------
PRIVILEGE NOT NULL NUMBER
NAME NOT NULL VARCHAR2(40)
SQL> desc tabquotas
Name Null? Type
----------------------------------------- --------
----------------------------
TNAME NOT NULL VARCHAR2(30)
TYPE VARCHAR2(7)
OBJNO NOT NULL NUMBER
NEXTEXT NUMBER
MAXEXT NOT NULL NUMBER
PINC NUMBER
PFREE NUMBER
PUSED NUMBER
SQL> desc tabs
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)
SQL> desc trusted_servers
Name Null? Type
----------------------------------------- --------
----------------------------
TRUST VARCHAR2(9)
NAME VARCHAR2(128)
SQL> spool off
No comments:
Post a Comment