|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ALL...
| CLU...
| IND...
| MVI...
| PRO...
| REP...
| SNA...
| TAB...
ALL_MVIEW_AGGREGATES: Description of the materialized view
aggregates accessible to the user
iSelfSchooling-SQL> desc ALL_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
ALL_MVIEW_ANALYSIS: Description of the materialized views accessible to the user
iSelfSchooling-SQL> desc ALL_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
ALL_MVIEW_COMMENTS: Comments on materialized views
accessible to the user
iSelfSchooling-SQL> desc ALL_MVIEW_COMMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
COMMENTS
VARCHAR2(4000)
ALL_MVIEW_DETAIL_RELATIONS: Description of the materialized view
detail tables accessible to the user
iSelfSchooling-SQL> desc ALL_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)
ALL_MVIEW_JOINS: Description of a join between two
columns in the WHERE clause of a materialized view accessible to the user
iSelfSchooling-SQL> desc ALL_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)
ALL_MVIEW_KEYS: Description of the columns that appear
in the GROUP BY list of a materialized view accessible to the user
iSelfSchooling-SQL> desc ALL_MVIEW_KEYS;
Name
Null?
Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
MVIEW_NAME
NOT NULL VARCHAR2(30)
POSITION_IN_SELECT
NOT NULL NUMBER
CONTAINER_COLUMN
NOT NULL VARCHAR2(30)
DETAILOBJ_OWNER
NOT NULL VARCHAR2(30)
DETAILOBJ_NAME
NOT NULL VARCHAR2(30)
DETAILOBJ_ALIAS
VARCHAR2(30)
DETAILOBJ_TYPE
VARCHAR2(5)
DETAILOBJ_COLUMN
NOT NULL VARCHAR2(30)
ALL_MVIEW_LOGS: All materialized view logs in the
database that the user can see
iSelfSchooling-SQL> desc ALL_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)
ALL_MVIEW_REFRESH_TIMES: Materialized views and their last
refresh times for each master table that the user can look at
iSelfSchooling-SQL> desc ALL_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
ALL_NESTED_TABLES: Description of nested tables in tables
accessible to the user
iSelfSchooling-SQL> desc ALL_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)
ALL_NESTED_TABLE_COLS: Columns of nested tables
iSelfSchooling-SQL> desc ALL_NESTED_TABLE_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)
ALL_OBJECTS: Objects accessible to the user
iSelfSchooling-SQL> desc ALL_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
SUBOBJECT_NAME
VARCHAR2(30)
OBJECT_ID
NOT NULL NUMBER
DATA_OBJECT_ID
NUMBER
OBJECT_TYPE
VARCHAR2(19)
CREATED
NOT NULL DATE
LAST_DDL_TIME
NOT NULL DATE
TIMESTAMP
VARCHAR2(19)
STATUS
VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED
VARCHAR2(1)
SECONDARY
VARCHAR2(1)
ALL_OBJECT_TABLES: Description of all object tables
accessible to the user
iSelfSchooling-SQL> desc ALL_OBJECT_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NUL |