|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ALL...
| CLU...
| IND...
| MVI...
| PRO...
| REP...
| SNA...
| TAB...
ALL_PROBE_OBJECTS
iSelfSchooling-SQL> desc ALL_PROBE_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)
DEBUGINFO
VARCHAR2(1)
ALL_PROCEDURES: Description of all procedures available
to the user
iSelfSchooling-SQL> desc ALL_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)
ALL_PROPAGATIONS: treams propagation seen by the user
iSelfSchooling-SQL> desc ALL_PROPAGATION;
Name
Null? Type
----------------------------- -------- --------------------
PROPAGATION_NAME
NOT NULL VARCHAR2(30)
SOURCE_QUEUE_OWNER
VARCHAR2(30)
SOURCE_QUEUE_NAME
VARCHAR2(30)
DESTINATION_QUEUE_OWNER
VARCHAR2(30)
DESTINATION_QUEUE_NAME
VARCHAR2(30)
DESTINATION_DBLINK
VARCHAR2(128)
RULE_SET_OWNER
VARCHAR2(30)
RULE_SET_NAME
VARCHAR2(30)
NEGATIVE_RULE_SET_OWNER
VARCHAR2(30)
NEGATIVE_RULE_SET_NAME
VARCHAR2(30)
QUEUE_TO_QUEUE
VARCHAR2(5)
STATUS
VARCHAR2(8)
ERROR_MESSAGE
VARCHAR2(4000)
ERROR_DATE
DATE
ALL_PUBLISHED_COLUMNS: Source columns available for Change
Data Capture
iSelfSchooling-SQL> desc ALL_PUBLISHED_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
CHANGE_SET_NAME
NOT NULL VARCHAR2(30)
PUB_ID
NOT NULL NUMBER
SOURCE_SCHEMA_NAME
NOT NULL VARCHAR2(30)
SOURCE_TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
DATA_TYPE
VARCHAR2(106)
DATA_LENGTH
NOT NULL NUMBER
DATA_PRECISION
NUMBER
DATA_SCALE
NUMBER
NULLABLE
VARCHAR2(1)
ALL_QUEUES: All queues accessible to the user
iSelfSchooling-SQL> desc ALL_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)
ALL_QUEUE_PUBLISHERS
iSelfSchooling-SQL> desc ALL_QUEUE_PUBLISHERS;
Name
Null? Type
----------------------------- -------- --------------------
QUEUE_OWNER
NOT NULL VARCHAR2(30)
QUEUE_NAME
NOT NULL VARCHAR2(30)
PUBLISHER_NAME
VARCHAR2(30)
PUBLISHER_ADDRESS
VARCHAR2(1024)
PUBLISHER_PROTOCOL
NUMBER
PUBLISHER_RULE
VARCHAR2(2000)
PUBLISHER_RULE_NAME
VARCHAR2(61)
PUBLISHER_RULESET
VARCHAR2(61)
PUBLISHER_TRANSFORMATION
VARCHAR2(61)
ALL_QUEUE_SUBSCRIBERS: All queue subscribers accessible to
user
iSelfSchooling-SQL> desc ALL_QUEUE_SUBSCRIBERS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT
NULL VARCHAR2(30)
QUEUE_NAME
NOT NULL VARCHAR2(30)
QUEUE_TABLE
NOT NULL VARCHAR2(30)
CONSUMER_NAME
VARCHAR2(30)
ADDRESS
VARCHAR2(1024)
PROTOCOL
NUMBER
TRANSFORMATION
VARCHAR2(61)
DELIVERY_MODE
VARCHAR2(22)
QUEUE_TO_QUEUE
VARCHAR2(5)
ALL_QUEUE_TABLES: All queue tables accessible to the user
iSelfSchooling-SQL> desc ALL_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)
ALL_REFRESH: All the refresh groups that the user
can touch
iSelfSchooling-SQL> desc ALL_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)
ALL_REFRESH_CHILDREN: All the objects in refresh groups,
where the user can touch the group
iSelfSchooling-SQL> desc ALL_REFRESH_CHILDREN;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT
NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
TYPE
VARCHAR2(30)
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)
ALL_REFRESH_DEPENDENCIES: Description of the detail tables that
materialized views depend on for refresh
iSelfSchooling-SQL> desc ALL_REFRESH_DEPENDENCIES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
PARENT_OBJECT_TYPE
CHAR(17)
OLDEST_REFRESH_SCN
NUMBER
OLDEST_REFRESH_DATE
DATE
ALL_REFS: Description of REF columns contained in
tables accessible to the user
iSelfSchooling-SQL> desc ALL_REFS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME |