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)
STATSTYPE_SCHEMA
VARCHAR2(30)
STATSTYPE_NAME
VARCHAR2(30)
DEF_SELECTIVITY
NUMBER
DEF_CPU_COST
NUMBER
DEF_IO_COST
NUMBER
DEF_NET_COST
NUMBER
INTERFACE_VERSION
NUMBER
DBA_ATTRIBUTE_TRANSFORMATIONS
iSelfSchooling-SQL> desc DBA_ATTRIBUTE_TRANSFORMATIONS;
Name
Null?
Type
----------------------------- -------- --------------------
TRANSFORMATION_ID
NOT NULL NUMBER
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
FROM_TYPE
VARCHAR2(61)
TO_TYPE
VARCHAR2(91)
ATTRIBUTE
NOT NULL NUMBER
ATTRIBUTE_TRANSFORMATION
VARCHAR2(4000)
DBA_AUDIT_EXISTS: Lists audit trail entries produced by AUDIT NOT
EXISTS and AUDIT EXISTS
iSelfSchooling-SQL> desc DBA_AUDIT_EXISTS;
Name
Null? Type
----------------------------- -------- --------------------
OS_USERNAME
VARCHAR2(255)
USERNAME
VARCHAR2(30)
USERHOST
VARCHAR2(128)
TERMINAL
VARCHAR2(255)
TIMESTAMP
DATE
OWNER
VARCHAR2(30)
OBJ_NAME
VARCHAR2(128)
ACTION_NAME
VARCHAR2(28)
NEW_OWNER
VARCHAR2(30)
NEW_NAME
VARCHAR2(128)
OBJ_PRIVILEGE
VARCHAR2(16)
SYS_PRIVILEGE
VARCHAR2(40)
GRANTEE
VARCHAR2(30)
SESSIONID
NOT NULL NUMBER
ENTRYID
NOT NULL NUMBER
STATEMENTID
NOT NULL NUMBER
RETURNCODE
NOT NULL NUMBER
CLIENT_ID
VARCHAR2(64)
ECONTEXT_ID
VARCHAR2(64)
SESSION_CPU
NUMBER
EXTENDED_TIMESTAMP
TIMESTAMP(6)
PROXY_SESSIONID
NUMBER
GLOBAL_UID
VARCHAR2(32)
INSTANCE_NUMBER
NUMBER
OS_PROCESS
VARCHAR2(16)
TRANSACTIONID
RAW(8)
SCN
NUMBER
SQL_BIND
NVARCHAR2(2000)
SQL_TEXT
NVARCHAR2(2000)
DBA_AUDIT_OBJECT: Audit trail records for statements concerning
objects, specifically: table, cluster, view, index, sequence, [public]
database link, [public] synonym, procedure, trigger, rollback segment,
tablespace, role, user
iSelfSchooling-SQL> desc DBA_AUDIT_OBJECT;
Name
Null? Type
----------------------------- -------- --------------------
OS_USERNAME
VARCHAR2(255)
USERNAME
VARCHAR2(30)
USERHOST
VARCHAR2(128)
TERMINAL
VARCHAR2(255)
TIMESTAMP
DATE
OWNER
VARCHAR2(30)
OBJ_NAME
VARCHAR2(128)
ACTION_NAME
VARCHAR2(28)
NEW_OWNER
VARCHAR2(30)
NEW_NAME
VARCHAR2(128)
SES_ACTIONS
VARCHAR2(19)
COMMENT_TEXT
VARCHAR2(4000)
SESSIONID
NOT NULL NUMBER
ENTRYID
NOT NULL NUMBER
STATEMENTID
NOT NULL NUMBER
RETURNCODE
NOT NULL NUMBER
PRIV_USED
VARCHAR2(40)
CLIENT_ID
VARCHAR2(64)
ECONTEXT_ID
VARCHAR2(64)
SESSION_CPU
NUMBER
EXTENDED_TIMESTAMP
TIMESTAMP(6)
PROXY_SESSIONID
NUMBER
GLOBAL_UID
VARCHAR2(32)
INSTANCE_NUMBER
NUMBER
OS_PROCESS
VARCHAR2(16)
TRANSACTIONID
RAW(8)
SCN
NUMBER
SQL_BIND
NVARCHAR2(2000)
SQL_TEXT
NVARCHAR2(2000)
DBA_AUDIT_POLICIES: Fine grained auditing policies in the database
iSelfSchooling-SQL> desc DBA_AUDIT_POLICIES;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_SCHEMA
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
POLICY_NAME
NOT NULL VARCHAR2(30)
POLICY_TEXT
VARCHAR2(4000)
POLICY_COLUMN
VARCHAR2(30)
PF_SCHEMA
VARCHAR2(30)
PF_PACKAGE
VARCHAR2(30)
PF_FUNCTION
VARCHAR2(30)
ENABLED &nbs |