|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ALL...
| CLU...
| IND...
| MVI...
| PRO...
| REP...
| SNA...
| TAB...
ALL_ALL_TABLES: Description of all object and
relational tables accessible to the user
iSelfSchooling-SQL> desc ALL_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)
ALL_APPLY: Details about each apply process that
dequeues from the queue visible to the current user
iSelfSchooling-SQL> desc ALL_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)
ALL_APPLY_CONFLICT_COLUMNS: Details about conflict resolution on tables visible to the current
user
iSelfSchooling-SQL> desc ALL_APPLY_CONFLICT_COLUMNS;
Name
Null?
Type
----------------------------- -------- --------------------
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
METHOD_NAME
VARCHAR2(92)
RESOLUTION_COLUMN
VARCHAR2(4000)
COLUMN_NAME
VARCHAR2(30)
APPLY_DATABASE_LINK
VARCHAR2(128)
ALL_APPLY_DML_HANDLERS: Details about the dml handler on tables
visible to the current user
iSelfSchooling-SQL> desc ALL_APPLY_DML_HANDLERS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
OPERATION_NAME
VARCHAR2(13)
USER_PROCEDURE
VARCHAR2(98)
ERROR_HANDLER
VARCHAR2(1)
APPLY_DATABASE_LINK
VARCHAR2(128)
APPLY_NAME
VARCHAR2(30)
ASSEMBLE_LOBS
VARCHAR2(1)
ALL_APPLY_ENQUEUE: Details about the apply enqueue action
for user accessible rules where the destination queue exists and is
visible to the user
iSelfSchooling-SQL> desc ALL_APPLY_ENQUEUE;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
DESTINATION_QUEUE_NAME
VARCHAR2(4000)
ALL_APPLY_ERROR: Error transactions that were generated
after dequeuing from the queue visible to the current user
iSelfSchooling-SQL> desc ALL_APPLY_ERROR;
Name
Null? Type
----------------------------- -------- --------------------
APPLY_NAME
VARCHAR2(30)
QUEUE_NAME
VARCHAR2(30)
QUEUE_OWNER
VARCHAR2(30)
LOCAL_TRANSACTION_ID
VARCHAR2(22)
SOURCE_DATABASE
VARCHAR2(128)
SOURCE_TRANSACTION_ID
VARCHAR2(22)
SOURCE_COMMIT_SCN
NUMBER
MESSAGE_NUMBER
NUMBER
ERROR_NUMBER
NUMBER
ERROR_MESSAGE
VARCHAR2(4000)
RECIPIENT_ID
NUMBER
RECIPIENT_NAME
VARCHAR2(30)
MESSAGE_COUNT
NUMBER
ERROR_CREATION_TIME
DATE
ALL_APPLY_EXECUTE: Details about the apply execute action for all rules visible to the
user
iSelfSchooling-SQL> desc ALL_APPLY_EXECUTE;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
EXECUTE_EVENT
VARCHAR2(2)
ALL_APPLY_KEY_COLUMNS: Alternative key columns for a STREAMS
table visible to the current user
iSelfSchooling-SQL> desc ALL_APPLY_KEY_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
APPLY_DATABASE_LINK
VARCHAR2(128)
ALL_APPLY_PARAMETERS: Details about parameters of each apply
process that dequeues from the queue visible to the current user
iSelfSchooling-SQL> desc ALL_APPLY_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
APPLY_NAME
NOT NULL VARCHAR2(30)
PARAMETER
NOT NULL VARCHAR2(128)
VALUE
VARCHAR2(4000)
SET_BY_USER
VARCHAR2(3)
ALL_APPLY_PROGRESS: Information about the progress made by
the apply process that dequeues from the queue visible to the current user
iSelfSchooling-SQL> desc ALL_APPLY_PROGRESS;
Name
Null? Type
----------------------------- -------- --------------------
APPLY_NAME
NOT NULL VARCHAR2(30)
SOURCE_DATABASE
NOT NULL VARCHAR2(128)
APPLIED_MESSAGE_NUMBER
NOT NULL NUMBER
OLDEST_MESSAGE_NUMBER
NOT NULL NUMBER
APPLY_TIME
DATE
APPLIED_MESSAGE_CREATE_TIME DATE
OLDEST_TRANSACTION_ID
VARCHAR2(22)
ALL_APPLY_TABLE_COLUMNS: Details about the columns of
destination table object visible to the user
iSelfSchooling-SQL> desc ALL_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)
ALL_ARGUMENTS: Arguments in object accessible to the
user
iSelfSchooling-SQL> desc ALL_ARGUMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
PACKAGE_NAME
VARCHAR2(30)
OBJECT_ID
NOT NULL NUMBER
OVERLOAD
VARCHAR2(40)
ARGUMENT_NAME
VARCHAR2(30)
POSITION
NOT NULL NUMBER
SEQUENCE
NOT NULL NUMBER
DATA_LEVEL
NOT NULL NUMBER
DATA_TYPE
VARCHAR2(30)
DEFAULT_VALUE
LONG
DEFAULT_LENGTH
NUMBER
IN_OUT
VARCHAR2(9)
DATA_LENGTH
NUMBER
DATA_PRECISION
NUMBER
DATA_SCALE
NUMBER
RADIX
NUMBER
CHARACTER_SET_NAME
VARCHAR2(44)
TYPE_OWNER
VARCHAR2(30)
TYPE_NAME
VARCHAR2(30)
TYPE_SUBNAME
VARCHAR2(30)
TYPE_LINK
VARCHAR2(128)
PLS_TYPE
VARCHAR2(30)
| 