|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ADV...
| AUD...
| FIL...
| LOB...
| PAR...
| REP...
| SEQ...
| TAB...
USER_SEQUENCES: Description of the user's own SEQUENCEs
iSelfSchooling-SQL> desc USER_SEQUENCES;
Name
Null? Type
----------------------------- -------- --------------------
SEQUENCE_NAME
NOT NULL VARCHAR2(30)
MIN_VALUE
NUMBER
MAX_VALUE
NUMBER
INCREMENT_BY
NOT NULL NUMBER
CYCLE_FLAG
VARCHAR2(1)
ORDER_FLAG
VARCHAR2(1)
CACHE_SIZE
NOT NULL NUMBER
LAST_NUMBER
NOT NULL NUMBER
USER_SNAPSHOTS: Snapshots the user can look at
iSelfSchooling-SQL> desc USER_SNAPSHOTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
MASTER_VIEW
VARCHAR2(30)
MASTER_OWNER
VARCHAR2(30)
MASTER
VARCHAR2(30)
MASTER_LINK
VARCHAR2(128)
CAN_USE_LOG
VARCHAR2(3)
UPDATABLE
VARCHAR2(3)
REFRESH_METHOD
VARCHAR2(11)
LAST_REFRESH
DATE
ERROR
NUMBER
FR_OPERATIONS
VARCHAR2(10)
CR_OPERATIONS
VARCHAR2(10)
TYPE
VARCHAR2(8)
NEXT
VARCHAR2(200)
START_WITH
DATE
REFRESH_GROUP
NUMBER
UPDATE_TRIG
VARCHAR2(30)
UPDATE_LOG
VARCHAR2(30)
QUERY
LONG
MASTER_ROLLBACK_SEG
VARCHAR2(30)
STATUS
VARCHAR2(7)
REFRESH_MODE
VARCHAR2(8)
PREBUILT
VARCHAR2(3)
USER_SNAPSHOT_LOGS: All snapshot logs owned by the user
iSelfSchooling-SQL> desc USER_SNAPSHOT_LOGS;
Name
Null? Type
----------------------------- -------- --------------------
LOG_OWNER
VARCHAR2(30)
MASTER
VARCHAR2(30)
LOG_TABLE
VARCHAR2(30)
LOG_TRIGGER
VARCHAR2(30)
ROWIDS
VARCHAR2(3)
PRIMARY_KEY
VARCHAR2(3)
OBJECT_ID
VARCHAR2(3)
FILTER_COLUMNS
VARCHAR2(3)
SEQUENCE
VARCHAR2(3)
INCLUDE_NEW_VALUES
VARCHAR2(3)
CURRENT_SNAPSHOTS
DATE
SNAPSHOT_ID
NUMBER
USER_SNAPSHOT_REFRESH_TIMES: Synonym for USER_MVIEW_REFRESH_TIMES
iSelfSchooling-SQL> desc USER_SNAPSHOT_REFRESH_TIMES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
MASTER_OWNER
VARCHAR2(30)
MASTER
VARCHAR2(30)
LAST_REFRESH
DATE
USER_SOURCE: Source of stored objects accessible to
the user
iSelfSchooling-SQL> desc USER_SOURCE;
Name
Null?
Type
----------------------------- -------- --------------------
NAME
VARCHAR2(30)
TYPE
VARCHAR2(12)
LINE
NUMBER
TEXT
VARCHAR2(4000)
USER_SOURCE_TABLES: Source tables available for Change Data
Capture
iSelfSchooling-SQL> desc USER_SOURCE_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
SOURCE_SCHEMA_NAME
NOT NULL VARCHAR2(30)
SOURCE_TABLE_NAME
NOT NULL VARCHAR2(30)
USER_SQLJ_TYPES: Description of the user's own types
iSelfSchooling-SQL> desc USER_SQLJ_TYPES;
Name
Null? Type
----------------------------- -------- --------------------
TYPE_NAME
NOT NULL VARCHAR2(30)
TYPE_OID
NOT NULL RAW(16)
EXTERNAL_NAME
VARCHAR2(4000)
USING
VARCHAR2(21)
TYPECODE
VARCHAR2(30)
ATTRIBUTES
NUMBER
METHODS
NUMBER
PREDEFINED
VARCHAR2(3)
INCOMPLETE
VARCHAR2(3)
FINAL
VARCHAR2(3)
INSTANTIABLE
VARCHAR2(3)
SUPERTYPE_OWNER
VARCHAR2(30)
SUPERTYPE_NAME
VARCHAR2(30)
LOCAL_ATTRIBUTES
NUMBER
LOCAL_METHODS
NUMBER
USER_SQLJ_TYPE_ATTRS: Description of attributes of the user's
own types
iSelfSchooling-SQL> desc USER_SQLJ_TYPE_ATTRS;
Name
Null? Type
----------------------------- -------- --------------------
TYPE_NAME
NOT NULL VARCHAR2(30)
ATTR_NAME
NOT NULL VARCHAR2(30)
EXTERNAL_ATTR_NAME
VARCHAR2(4000)
ATTR_TYPE_MOD
VARCHAR2(7)
ATTR_TYPE_OWNER
VARCHAR2(30)
ATTR_TYPE_NAME
VARCHAR2(30)
LENGTH
NUMBER
PRECISION
NUMBER
SCALE
NUMBER
CHARACTER_SET_NAME
VARCHAR2(44)
ATTR_NO
NOT NULL NUMBER
INHERITED
VARCHAR2(3)
USER_SQLJ_TYPE_METHODS: Description of methods of the user's own types
iSelfSchooling-SQL> desc USER_SQLJ_TYPE_METHODS;
Name
Null? Type
----------------------------- -------- --------------------
TYPE_NAME
NOT NULL VARCHAR2(30)
METHOD_NAME
NOT NULL VARCHAR2(30)
EXTERNAL_VAR_NAME
VARCHAR2(4000)
METHOD_NO
NOT NULL NUMBER
METHOD_TYPE
VARCHAR2(6)
PARAMETERS
NOT NULL NUMBER
RESULTS
NOT NULL NUMBER
FINAL
VARCHAR2(3)
INSTANTIABLE
VARCHAR2(3)
OVERRIDING
VARCHAR2(3)
INHERITED
VARCHAR2(3)
USER_SQLSET
iSelfSchooling-SQL> desc USER_SQLSET;
Name
Null? Type
----------------------------- -------- --------------------
NAME
NOT NULL VARCHAR2(30)
ID
NOT NULL NUMBER
DESCRIPTION
VARCHAR2(256)
CREATED
DATE
LAST_MODIFIED
DATE
STATEMENT_COUNT
NUMBER
USER_SQLSET_BINDS
iSelfSchooling-SQL> desc USER_SQLSET_BINDS;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
VARCHAR2(30)
SQLSET_ID
NUMBER
SQL_ID
VARCHAR2(13)
FORCE_MATCHING_SIGNATURE
NUMBER
PLAN_HASH_VALUE
NUMBER
POSITION
NUMBER
VALUE
ANYDATA
CAPTURED
CHAR(1)
SQL_SEQ
NUMBER
USER_SQLSET_DEFINITIONS: Synonym for USER_SQLSET
iSelfSchooling-SQL> desc USER_SQLSET_DEFINITIONS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
NOT NULL VARCHAR2(30)
ID
NOT NULL NUMBER
DESCRIPTION
VARCHAR2(256)
CREATED
DATE
LAST_MODIFIED
DATE
STATEMENT_COUNT
NUMBER
USER_SQLSET_PLANS
iSelfSchooling-SQL> desc USER_SQLSET_PLANS;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
NOT NULL VARCHAR2(30)
SQLSET_ID
NOT NULL NUMBER
SQL_ID
NOT NULL VARCHAR2(13)
FORCE_MATCHING_SIGNATURE
NOT NULL NUMBER
PLAN_HASH_VALUE
NOT NULL NUMBER
SQL_SEQ
NOT NULL NUMBER
STATEMENT_ID
VARCHAR2(30)
PLAN_ID
NUMBER
TIMESTAMP
DATE
REMARKS
VARCHAR2(4000)
OPERATION
VARCHAR2(30)
OPTIONS
VARCHAR2(255)
OBJECT_NODE
VARCHAR2(128)
OBJECT_OWNER &n |