|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ADV...
| AUD...
| FIL...
| LOB...
| PAR...
| REP...
| SEQ...
| TAB...
USER_LOB_SUBPARTITIONS
iSelfSchooling-SQL> desc USER_LOB_SUBPARTITIONS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
LOB_NAME
NOT NULL VARCHAR2(30)
LOB_PARTITION_NAME
VARCHAR2(30)
SUBPARTITION_NAME
VARCHAR2(30)
LOB_SUBPARTITION_NAME
VARCHAR2(30)
LOB_INDSUBPART_NAME
VARCHAR2(30)
SUBPARTITION_POSITION
NUMBER
CHUNK
NUMBER
PCTVERSION
NOT NULL NUMBER
CACHE
VARCHAR2(10)
IN_ROW
VARCHAR2(3)
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NOT NULL NUMBER
MAX_EXTENTS
NOT NULL NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
LOGGING
VARCHAR2(3)
BUFFER_POOL
VARCHAR2(7)
USER_LOB_TEMPLATES
iSelfSchooling-SQL> desc USER_LOB_TEMPLATES;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
LOB_COL_NAME
VARCHAR2(4000)
SUBPARTITION_NAME
NOT NULL VARCHAR2(34)
LOB_SEGMENT_NAME
NOT NULL VARCHAR2(34)
TABLESPACE_NAME
VARCHAR2(30)
USER_LOG_GROUPS: Log group definitions on user's own
tables
iSelfSchooling-SQL> desc USER_LOG_GROUPS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
LOG_GROUP_NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
LOG_GROUP_TYPE
VARCHAR2(19)
ALWAYS
VARCHAR2(11)
GENERATED
VARCHAR2(14)
USER_LOG_GROUP_COLUMNS: Information about columns in log group
definitions
iSelfSchooling-SQL> desc USER_LOG_GROUP_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
LOG_GROUP_NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
POSITION
NUMBER
LOGGING_PROPERTY
VARCHAR2(6)
USER_METHOD_PARAMS: Description of method parameters of the
user's own types
iSelfSchooling-SQL> desc USER_METHOD_PARAMS;
Name
Null? Type
----------------------------- -------- --------------------
TYPE_NAME
NOT NULL VARCHAR2(30)
METHOD_NAME
NOT NULL VARCHAR2(30)
METHOD_NO
NOT NULL NUMBER
PARAM_NAME
NOT NULL VARCHAR2(30)
PARAM_NO
NOT NULL NUMBER
PARAM_MODE
VARCHAR2(6)
PARAM_TYPE_MOD
VARCHAR2(7)
PARAM_TYPE_OWNER
VARCHAR2(30)
PARAM_TYPE_NAME
VARCHAR2(30)
CHARACTER_SET_NAME
VARCHAR2(44)
USER_METHOD_RESULTS: Description of method results of the
user's own types
iSelfSchooling-SQL> desc USER_METHOD_RESULTS;
Name
Null? Type
----------------------------- -------- --------------------
TYPE_NAME
NOT NULL VARCHAR2(30)
METHOD_NAME
NOT NULL VARCHAR2(30)
METHOD_NO
NOT NULL NUMBER
RESULT_TYPE_MOD
VARCHAR2(7)
RESULT_TYPE_OWNER
VARCHAR2(30)
RESULT_TYPE_NAME
VARCHAR2(30)
CHARACTER_SET_NAME
VARCHAR2(44)
USER_MVIEWS: All materialized views in the database
iSelfSchooling-SQL> desc USER_MVIEWS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
CONTAINER_NAME
NOT NULL VARCHAR2(30)
QUERY
LONG
QUERY_LEN
NUMBER(38)
UPDATABLE
VARCHAR2(1)
UPDATE_LOG
VARCHAR2(30)
MASTER_ROLLBACK_SEG
VARCHAR2(30)
MASTER_LINK
VARCHAR2(128)
REWRITE_ENABLED
VARCHAR2(1)
REWRITE_CAPABILITY
VARCHAR2(9)
REFRESH_MODE
VARCHAR2(6)
REFRESH_METHOD
VARCHAR2(8)
BUILD_MODE
VARCHAR2(9)
FAST_REFRESHABLE
VARCHAR2(18)
LAST_REFRESH_TYPE
VARCHAR2(8)
LAST_REFRESH_DATE
DATE
STALENESS
VARCHAR2(19)
AFTER_FAST_REFRESH
VARCHAR2(19)
UNKNOWN_PREBUILT
VARCHAR2(1)
UNKNOWN_PLSQL_FUNC
VARCHAR2(1)
UNKNOWN_EXTERNAL_TABLE
VARCHAR2(1)
UNKNOWN_CONSIDER_FRESH
VARCHAR2(1)
UNKNOWN_IMPORT
VARCHAR2(1)
UNKNOWN_TRUSTED_FD
VARCHAR2(1)
COMPILE_STATE
VARCHAR2(19)
USE_NO_INDEX
VARCHAR2(1)
STALE_SINCE
DATE
USER_MVIEW_AGGREGATES: Description of the materialized view
aggregates created by the user
iSelfSchooling-SQL> desc USER_MVIEW_AGGREGATES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
POSITION_IN_SELECT
NOT NULL NUMBER
CONTAINER_COLUMN
NOT NULL VARCHAR2(30)
AGG_FUNCTION
VARCHAR2(8)
DISTINCTFLAG
VARCHAR2(1)
MEASURE
LONG
USER_MVIEW_ANALYSIS: Description of the materialized views
created by the user
iSelfSchooling-SQL> desc USER_MVIEW_ANALYSIS;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
MVIEW_TABLE_OWNER
NOT NULL VARCHAR2(30)
CONTAINER_NAME
VARCHAR2(30)
LAST_REFRESH_SCN
NUMBER
LAST_REFRESH_DATE
DATE
REFRESH_METHOD
VARCHAR2(8)
SUMMARY
VARCHAR2(1)
FULLREFRESHTIM
NUMBER
INCREFRESHTIM
NUMBER
CONTAINS_VIEWS
VARCHAR2(1)
UNUSABLE
VARCHAR2(1)
RESTRICTED_SYNTAX
VARCHAR2(1)
INC_REFRESHABLE
VARCHAR2(1)
KNOWN_STALE
VARCHAR2(1)
INVALID
VARCHAR2(1)
REWRITE_ENABLED
VARCHAR2(1)
QUERY_LEN
NUMBER
QUERY
LONG
REVISION
NOT NULL NUMBER
USER_MVIEW_COMMENTS: Comments on materialized views owned by
the user
iSelfSchooling-SQL> desc USER_MVIEW_COMMENTS;
Name
Null? Type
----------------------------- -------- --------------------
MVIEW_NAME
NOT NULL VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
USER_MVIEW_DETAIL_RELATIONS: Description of the materialized view
detail tables of the materialized views created by the user
iSelfSchooling-SQL> desc USER_MVIEW_DETAIL_RELATIONS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
DETAILOBJ_OWNER
NOT NULL VARCHAR2(30)
DETAILOBJ_NAME
NOT NULL VARCHAR2(30)
DETAILOBJ_TYPE
VARCHAR2(9)
DETAILOBJ_ALIAS
VARCHAR2(30)
USER_MVIEW_JOINS: Description of a join between two
columns in the WHERE clause of a materialized view created by the user
iSelfSchooling-SQL> desc USER_MVIEW_JOINS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT
NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
DETAILOBJ1_OWNER
NOT NULL VARCHAR2(30)
DETAILOBJ1_RELATION
NOT NULL VARCHAR2(30)
DETAILOBJ1_COLUMN
NOT NULL VARCHAR2(30)
OPERATOR
CHAR(1)
OPERATOR_TYPE
VARCHAR2(1)
DETAILOBJ2_OWNER
NOT NULL VARCHAR2(30)
DETAILOBJ2_RELATION
NOT NULL VARCHAR2(30)
DETAILOBJ2_COLUMN
NOT NULL VARCHAR2(30)
USER_MVIEW_KEYS: Description of the columns that appear
in the GROUP BY list of a materialized view created by the user
iSelfSchooling-SQL> desc USER_MVIEW_KEYS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
POSITION_IN_SELECT
NOT NULL NUMBER
CONTAINER_COLUMN
NOT NULL VARCHAR2(30)
DETAILOBJ_OWNER
NOT NULL VARCHAR2(30)
|