|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_APPLY: Details about the apply process
iSelfSchooling-SQL> desc DBA_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)
DBA_APPLY_CONFLICT_COLUMNS: Details about conflict resolution
iSelfSchooling-SQL> desc DBA_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)
DBA_APPLY_DML_HANDLERS: Details about the dml handler
iSelfSchooling-SQL> desc DBA_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)
DBA_APPLY_ENQUEUE: Details about the apply enqueue action
iSelfSchooling-SQL> desc DBA_APPLY_ENQUEUE;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
DESTINATION_QUEUE_NAME
VARCHAR2(4000)
DBA_APPLY_ERROR: Error transactions
iSelfSchooling-SQL> desc DBA_APPLY_ERROR;
Name
Null? Type
----------------------------- -------- --------------------
APPLY_NAME
VARCHAR2(30)
QUEUE_NAME
NOT NULL VARCHAR2(30)
QUEUE_OWNER
NOT NULL 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
DBA_APPLY_EXECUTE: Details about the apply execute action
iSelfSchooling-SQL> desc DBA_APPLY_EXECUTE;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
EXECUTE_EVENT
VARCHAR2(2)
DBA_APPLY_INSTANTIATED_GLOBAL:
Details
about database instantiated
iSelfSchooling-SQL> desc DBA_APPLY_INSTANTIATED_GLOBAL;
Name
Null? Type
----------------------------- -------- --------------------
SOURCE_DATABASE
NOT NULL VARCHAR2(128)
INSTANTIATION_SCN
NUMBER
APPLY_DATABASE_LINK
VARCHAR2(128)
DBA_APPLY_INSTANTIATED_OBJECTS:
Details
about objects instantiated
iSelfSchooling-SQL> desc DBA_APPLY_INSTANTIATED_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
SOURCE_DATABASE
NOT NULL VARCHAR2(128)
SOURCE_OBJECT_OWNER
NOT NULL VARCHAR2(30)
SOURCE_OBJECT_NAME
NOT NULL VARCHAR2(30)
SOURCE_OBJECT_TYPE
VARCHAR2(11)
INSTANTIATION_SCN
NUMBER
IGNORE_SCN
NUMBER
APPLY_DATABASE_LINK
VARCHAR2(128)
DBA_APPLY_INSTANTIATED_SCHEMAS:
Details
about schemas instantiated
iSelfSchooling-SQL> desc DBA_APPLY_INSTANTIATED_SCHEMAS;
Name
Null?
Type
----------------------------- -------- --------------------
SOURCE_DATABASE
NOT NULL VARCHAR2(128)
SOURCE_SCHEMA
VARCHAR2(30)
INSTANTIATION_SCN
NUMBER
APPLY_DATABASE_LINK
VARCHAR2(128)
DBA_APPLY_KEY_COLUMNS: alternative key columns for a table for STREAMS
iSelfSchooling-SQL> desc DBA_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)
DBA_APPLY_OBJECT_DEPENDENCIES:
Synonym
for _DBA_APPLY_OBJECT_CONSTRAINTS
iSelfSchooling-SQL> desc DBA_APPLY_OBJECT_DEPENDENCIES;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
PARENT_OBJECT_OWNER
NOT NULL VARCHAR2(30)
PARENT_OBJECT_NAME
NOT NULL VARCHAR2(30)
DBA_APPLY_PARAMETERS: All parameters for apply process
iSelfSchooling-SQL> desc DBA_APPLY_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
APPLY_NAME
NOT NULL VARCHAR2(30)
PARAMETER
NOT NULL VARCHAR2(128)
VALUE
VARCHAR2(4000)
SET_BY_USER
VARCHAR2(3)
DBA_APPLY_PROGRESS: Information about the progress made by apply
process
iSelfSchooling-SQL> desc DBA_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)
DBA_APPLY_SPILL_TXNS: treams apply spilled transactions info
iSelfSchooling-SQL> desc DBA_APPLY_SPILL_TXN;
Name
Null? Type
----------------------------- -------- --------------------
APPLY_NAME
NOT NULL VARCHAR2(30)
XIDUSN
NOT NULL NUMBER
XIDSLT
NOT NULL NUMBER
XIDSQN NOT
NULL NUMBER
FIRST_SCN
NOT NULL NUMBER
MESSAGE_COUNT
NUMBER
FIRST_MESSAGE_CREATE_TIME
DATE
SPILL_CREATION_TIME
DATE
DBA_APPLY_TABLE_COLUMNS: Details about the destination table columns
iSelfSchooling-SQL> desc DBA_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)
DBA_APPLY_VALUE_DEPENDENCIES:
Synonym
for _DBA_APPLY_CONSTRAINT_COLUMNS
iSelfSchooling-SQL> desc DBA_APPLY_VALUE_DEPENDENCIES;
Name
Null? Type
----------------------------- -------- --------------------
DEPENDENCY_NAME
NOT
NULL VARCHAR2(30)
OBJECT_OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
COLUMN_POSITION
NUMBER
DBA_AQ_AGENTS
iSelfSchooling-SQL> desc DBA_AQ_AGENTS;
Name
Null? Type
----------------------------- -------- --------------------
AGENT_NAME
NOT NULL VARCHAR2(30)
HTTP_ENABLED
VARCHAR2(4)
SMTP_ENABLED
VARCHAR2(4)
DBA_AQ_AGENT_PRIVS
iSelfSchooling-SQL> desc DBA_AQ_AGENT_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
AGENT_NAME
NOT NULL VARCHAR2(30)
DB_USERNAME
VARCHAR2(30)
HTTP_ENABLED
VARCHAR2(4)
SMTP_ENABLED
VARCHAR2(4)
DBA_ASSOCIATIONS: All associations
iSelfSchooling-SQL> desc DBA_ASSOCIATIONS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(30)
OBJECT_TYPE
VARCHAR2(9)
|