ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_SCHEDULER_WINDOW_LOG: Logged information for all scheduler windows
iSelfSchooling-SQL> desc DBA_SCHEDULER_WINDOW_LOG;
Name
Null? Type
----------------------------- -------- --------------------
LOG_ID
NOT NULL NUMBER
LOG_DATE
TIMESTAMP(6)
WINDOW_NAME
VARCHAR2(65)
OPERATION
VARCHAR2(30)
STATUS
VARCHAR2(30)
USER_NAME
VARCHAR2(30)
CLIENT_ID
VARCHAR2(64)
GLOBAL_UID
VARCHAR2(32)
ADDITIONAL_INFO
CLOB
DBA_SCHEDULER_WINGROUP_MEMBERS:
Members
of all scheduler window groups in the database
iSelfSchooling-SQL> desc DBA_SCHEDULER_WINGROUP_MEMBERS;
Name
Null? Type
----------------------------- -------- --------------------
WINDOW_GROUP_NAME
NOT NULL VARCHAR2(30)
WINDOW_NAME
NOT NULL VARCHAR2(30)
DBA_SECONDARY_OBJECTS: All secondary objects for domain indexes
iSelfSchooling-SQL> desc DBA_SECONDARY_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_OWNER
NOT NULL VARCHAR2(30)
INDEX_NAME
NOT NULL VARCHAR2(30)
SECONDARY_OBJECT_OWNER
NOT NULL VARCHAR2(30)
SECONDARY_OBJECT_NAME
NOT NULL VARCHAR2(30)
DBA_SEC_RELEVANT_COLS: Security Relevant columns of all VPD policies in
the database
iSelfSchooling-SQL> desc DBA_SEC_RELEVANT_COLS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT
NULL VARCHAR2(30)
POLICY_GROUP
NOT NULL VARCHAR2(30)
POLICY_NAME
NOT NULL VARCHAR2(30)
SEC_REL_COLUMN
NOT NULL VARCHAR2(30)
COLUMN_OPTION
VARCHAR2(8)
DBA_SEGMENTS: Storage allocated for all database segments
iSelfSchooling-SQL> desc DBA_SEGMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
SEGMENT_NAME
VARCHAR2(81)
PARTITION_NAME
VARCHAR2(30)
SEGMENT_TYPE
VARCHAR2(18)
TABLESPACE_NAME
VARCHAR2(30)
HEADER_FILE
NUMBER
HEADER_BLOCK
NUMBER
BYTES
NUMBER
BLOCKS
NUMBER
EXTENTS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
RELATIVE_FNO
NUMBER
BUFFER_POOL
VARCHAR2(7)
DBA_SEGMENTS_OLD: Storage allocated for all database segments
iSelfSchooling-SQL> desc DBA_SEGMENTS_OLD;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
VARCHAR2(30)
SEGMENT_NAME
VARCHAR2(81)
PARTITION_NAME
VARCHAR2(30)
SEGMENT_TYPE
VARCHAR2(18)
TABLESPACE_NAME
VARCHAR2(30)
HEADER_FILE
NUMBER
HEADER_BLOCK
NUMBER
BYTES
NUMBER
BLOCKS
NUMBER
EXTENTS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
RELATIVE_FNO
NUMBER
BUFFER_POOL
VARCHAR2(7)
DBA_SEQUENCES: Description of all SEQUENCEs in the database
iSelfSchooling-SQL> desc DBA_SEQUENCES;
Name
Null? Type
----------------------------- -------- --------------------
SEQUENCE_OWNER
NOT NULL VARCHAR2(30)
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
DBA_SERVER_REGISTRY
iSelfSchooling-SQL> desc DBA_SERVER_REGISTRY;
Name
Null? Type
----------------------------- -------- --------------------
COMP_ID
NOT NULL VARCHAR2(30)
COMP_NAME
VARCHAR2(255)
VERSION
VARCHAR2(30)
STATUS
VARCHAR2(11)
MODIFIED
VARCHAR2(20)
CONTROL
NOT NULL VARCHAR2(30)
SCHEMA
NOT NULL VARCHAR2(30)
PROCEDURE
VARCHAR2(61)
STARTUP
VARCHAR2(8)
PARENT_ID
VARCHAR2(30)
OTHER_SCHEMAS
VARCHAR2(4000)
DBA_SNAPSHOTS: All snapshots in the database
iSelfSchooling-SQL> desc DBA_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)
DBA_SNAPSHOT_LOGS: All snapshot logs in the database
iSelfSchooling-SQL> desc DBA_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(38)
DBA_SNAPSHOT_LOG_FILTER_COLS:
Synonym
for DBA_MVIEW_LOG_FILTER_COLS
iSelfSchooling-SQL> desc DBA_SNAPSHOT_LOG_FILTER_COLS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(30)
DBA_SNAPSHOT_REFRESH_TIMES: Synonym for DBA_MVIEW_REFRESH_TIMES
iSelfSchooling-SQL> desc DBA_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
DBA_SOURCE: Source of all stored objects in the database
iSelfSchooling-SQL> desc DBA_SOURCE;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
NAME
VARCHAR2(30)
TYPE
VARCHAR2(12)
LINE
NUMBER
TEXT
VARCHAR2(4000)
DBA_SOURCE_TABLES: Source tables available for Change Data Capture
iSelfSchooling-SQL> desc DBA_SOURCE_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
SOURCE_SCHEMA_NAME
NOT NULL VARCHAR2(30)
SOURCE_TABLE_NAME
NOT NULL VARCHAR2(30)
DBA_SQLJ_TYPES: Description of all types in the database
iSelfSchooling-SQL> desc DBA_SQLJ_TYPES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
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
DBA_SQLJ_TYPE_ATTRS: Description of attributes of all types in the
database
iSelfSchooling-SQL> desc DBA_SQLJ_TYPE_ATTRS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
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)
DBA_SQLJ_TYPE_METHODS: Description of methods of all types in the
database
iSelfSchooling-SQL> desc DBA_SQLJ_TYPE_METHODS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
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)
DBA_SQLSET
iSelfSchooling-SQL> desc DBA_SQLSET;
Name
Null? Type
----------------------------- -------- --------------------
ID
NOT NULL NUMBER
NAME
NOT NULL VARCHAR2(30)
OWNER
VARCHAR2(30)
DESCRIPTION
VARCHAR2(256)
CREATED
DATE
LAST_MODIFIED
DATE
STATEMENT_COUNT
NUMBER
DBA_SQLSET_BINDS
iSelfSchooling-SQL> desc DBA_SQLSET_BINDS;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
VARCHAR2(30)
SQLSET_OWNER
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
DBA_SQLSET_DEFINITIONS: Synonym for DBA_SQLSET
iSelfSchooling-SQL> desc DBA_SQLSET_DEFINITIONS;
Name
Null? Type
----------------------------- -------- --------------------
ID
NOT
NULL NUMBER
NAME
NOT NULL VARCHAR2(30)
OWNER
VARCHAR2(30)
DESCRIPTION
VARCHAR2(256)
CREATED
DATE
LAST_MODIFIED
DATE
STATEMENT_COUNT
NUMBER
DBA_SQLSET_PLANS
iSelfSchooling-SQL> desc DBA_SQLSET_PLANS;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
NOT NULL VARCHAR2(30)
SQLSET_OWNER
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
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
OBJECT_ALIAS
VARCHAR2(65)
OBJECT_INSTANCE
NUMBER(38)
OBJECT_TYPE
VARCHAR2(30)
OPTIMIZER
VARCHAR2(255)
SEARCH_COLUMNS
NUMBER
ID
NOT NULL NUMBER(38)
PARENT_ID
NUMBER(38)
DEPTH
NUMBER(38)
POSITION
NUMBER(38)
COST
NUMBER(38)
CARDINALITY
NUMBER(38)
BYTES
NUMBER(38)
OTHER_TAG
VARCHAR2(255)
PARTITION_START
VARCHAR2(255)
PARTITION_STOP
VARCHAR2(255)
PARTITION_ID
NUMBER(38)
OTHER
LONG
DISTRIBUTION
VARCHAR2(30)
CPU_COST
NUMBER(38)
IO_COST
NUMBER(38)
TEMP_SPACE
NUMBER(38)
ACCESS_PREDICATES
VARCHAR2(4000)
FILTER_PREDICATES
VARCHAR2(4000)
PROJECTION
VARCHAR2(4000)
TIME
NUMBER(38)
QBLOCK_NAME
VARCHAR2(30)
OTHER_XML
CLOB
EXECUTIONS
NUMBER
STARTS
NUMBER
OUTPUT_ROWS
NUMBER
CR_BUFFER_GETS
NUMBER
CU_BUFFER_GETS
NUMBER
DISK_READS
NUMBER
DISK_WRITES
NUMBER
ELAPSED_TIME
NUMBER
DBA_SQLSET_REFERENCES
iSelfSchooling-SQL> desc DBA_SQLSET_REFERENCES;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
NOT NULL VARCHAR2(30)
SQLSET_OWNER
VARCHAR2(30)
SQLSET_ID
NOT NULL NUMBER
ID
NOT NULL NUMBER
OWNER
VARCHAR2(30)
CREATED
DATE
DESCRIPTION
VARCHAR2(256)
DBA_SQLSET_STATEMENTS
iSelfSchooling-SQL> desc DBA_SQLSET_STATEMENTS;
Name
Null? Type
----------------------------- -------- --------------------
SQLSET_NAME
NOT NULL VARCHAR2(30)
SQLSET_OWNER
VARCHAR2(30)
SQLSET_ID
NOT NULL NUMBER
SQL_ID
NOT NULL VARCHAR2(13)
FORCE_MATCHING_SIGNATURE
NOT NULL NUMBER
SQL_TEXT
CLOB
PARSING_SCHEMA_NAME
VARCHAR2(30)
PARSING_SCHEMA_ID
NUMBER
PLAN_HASH_VALUE
NOT NULL NUMBER
BIND_DATA
RAW(2000)
BINDS_CAPTURED
CHAR(1)
MODULE
VARCHAR2(48)
ACTION
VARCHAR2(32)
ELAPSED_TIME
NUMBER
CPU_TIME
NUMBER
BUFFER_GETS
NUMBER
DISK_READS
NUMBER
DIRECT_WRITES
NUMBER
ROWS_PROCESSED
NUMBER
FETCHES
NUMBER
EXECUTIONS
NUMBER
END_OF_FETCH_COUNT
NUMBER
OPTIMIZER_COST
NUMBER
OPTIMIZER_ENV
RAW(1000)
PRIORITY
NUMBER
COMMAND_TYPE
NUMBER
FIRST_LOAD_TIME
VARCHAR2(19)
STAT_PERIOD
NUMBER
ACTIVE_STAT_PERIOD
NUMBER
OTHER
CLOB
PLAN_TIMESTAMP
DATE
SQL_SEQ
NOT NULL NUMBER
DBA_SQLTUNE_BINDS
iSelfSchooling-SQL> desc DBA_SQLTUNE_BINDS;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER(38)
OBJECT_ID
NOT NULL NUMBER(38)
POSITION
NOT
NULL NUMBER(38)
VALUE
ANYDATA
DBA_SQLTUNE_PLANS
iSelfSchooling-SQL> desc DBA_SQLTUNE_PLANS;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER(38)
OBJECT_ID
NOT NULL NUMBER(38)
ATTRIBUTE
VARCHAR2(27)
STATEMENT_ID
VARCHAR2(30)
PLAN_HASH_VALUE
NOT NULL NUMBER
PLAN_ID
NUMBER
TIMESTAMP
DATE
REMARKS
VARCHAR2(4000)
OPERATION
VARCHAR2(30)
OPTIONS
VARCHAR2(255)
OBJECT_NODE
VARCHAR2(128)
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
OBJECT_ALIAS
VARCHAR2(65)
OBJECT_INSTANCE
NUMBER(38)
OBJECT_TYPE
VARCHAR2(30)
OPTIMIZER
VARCHAR2(255)
SEARCH_COLUMNS
NUMBER
ID
NOT NULL NUMBER(38)
PARENT_ID
NUMBER(38)
DEPTH
NUMBER(38)
POSITION
NUMBER(38)
COST
NUMBER(38)
CARDINALITY
NUMBER(38)
BYTES
NUMBER(38)
OTHER_TAG
VARCHAR2(255)
PARTITION_START
VARCHAR2(255)
PARTITION_STOP
VARCHAR2(255)
PARTITION_ID
NUMBER(38)
OTHER
LONG
DISTRIBUTION
VARCHAR2(30)
CPU_COST
NUMBER(38)
IO_COST
NUMBER(38)
TEMP_SPACE
NUMBER(38)
ACCESS_PREDICATES
VARCHAR2(4000)
FILTER_PREDICATES
VARCHAR2(4000)
PROJECTION
VARCHAR2(4000)
TIME
NUMBER(38)
QBLOCK_NAME
VARCHAR2(30)
OTHER_XML
CLOB
DBA_SQLTUNE_RATIONALE_PLAN
iSelfSchooling-SQL> desc DBA_SQLTUNE_RATIONALE_PLAN;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER(38)
RATIONALE_ID
NOT NULL NUMBER(38)
OBJECT_ID
NOT NULL NUMBER(38)
OPERATION_ID
NOT NULL NUMBER(38)
PLAN_ATTRIBUTE
VARCHAR2(27)
DBA_SQLTUNE_STATISTICS
iSelfSchooling-SQL> desc DBA_SQLTUNE_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
TASK_ID
NOT NULL NUMBER(38)
OBJECT_ID
NOT NULL NUMBER(38)
PARSING_SCHEMA_ID
NUMBER
MODULE
VARCHAR2(48)
ACTION
VARCHAR2(32)
ELAPSED_TIME
NUMBER
CPU_TIME
NUMBER
BUFFER_GETS
NUMBER
DISK_READS
NUMBER
DIRECT_WRITES
NUMBER
ROWS_PROCESSED
NUMBER
FETCHES
NUMBER
EXECUTIONS
NUMBER
END_OF_FETCH_COUNT
NUMBER
OPTIMIZER_COST
NUMBER
OPTIMIZER_ENV
RAW(1000)
COMMAND_TYPE
NUMBER
DBA_STMT_AUDIT_OPTS: Describes current system auditing options across
the system and by user
iSelfSchooling-SQL> desc DBA_STMT_AUDIT_OPTS;
Name
Null? Type
----------------------------- -------- --------------------
USER_NAME
VARCHAR2(30)
PROXY_NAME
VARCHAR2(30)
AUDIT_OPTION
NOT NULL VARCHAR2(40)
SUCCESS
VARCHAR2(10)
FAILURE
VARCHAR2(10)
DBA_STORED_SETTINGS: Parameter settings for all objects
iSelfSchooling-SQL> desc DBA_STORED_SETTINGS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
OBJECT_ID
NOT NULL
NUMBER
OBJECT_TYPE
VARCHAR2(12)
PARAM_NAME
NOT NULL VARCHAR2(30)
PARAM_VALUE
VARCHAR2(4000)
DBA_STREAMS_ADD_COLUMN: Add column transformations
iSelfSchooling-SQL> desc DBA_STREAMS_ADD_COLUMN;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
VARCHAR2(30)
RULE_NAME
VARCHAR2(30)
SCHEMA_NAME
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
COLUMN_VALUE
ANYDATA
COLUMN_TYPE
VARCHAR2(4000)
COLUMN_FUNCTION
VARCHAR2(30)
VALUE_TYPE
VARCHAR2(3)
PRECEDENCE
NUMBER
STEP_NUMBER
NUMBER
DBA_STREAMS_ADMINISTRATOR: Users granted the privileges to be a streams
administrator
iSelfSchooling-SQL> desc DBA_STREAMS_ADMINISTRATOR;
Name
Null? Type
----------------------------- -------- --------------------
USERNAME
NOT NULL VARCHAR2(30)
LOCAL_PRIVILEGES
VARCHAR2(3)
ACCESS_FROM_REMOTE
VARCHAR2(3)
DBA_STREAMS_DELETE_COLUMN: Delete column transformations
iSelfSchooling-SQL> desc DBA_STREAMS_DELETE_COLUMN;
Name
Null? Type
-----------------------------
-------- --------------------
RULE_OWNER
VARCHAR2(30)
RULE_NAME
VARCHAR2(30)
SCHEMA_NAME
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
VALUE_TYPE
VARCHAR2(3)
PRECEDENCE
NUMBER
STEP_NUMBER
NUMBER
DBA_STREAMS_GLOBAL_RULES: Global rules created by streams administrative
APIs
iSelfSchooling-SQL> desc DBA_STREAMS_GLOBAL_RULES;
Name
Null? Type
----------------------------- -------- --------------------
STREAMS_NAME
VARCHAR2(30)
STREAMS_TYPE
VARCHAR2(11)
RULE_TYPE
VARCHAR2(7)
INCLUDE_TAGGED_LCR
VARCHAR2(3)
SOURCE_DATABASE
VARCHAR2(128)
RULE_NAME
VARCHAR2(30)
RULE_OWNER
VARCHAR2(30)
RULE_CONDITION
VARCHAR2(4000)
DBA_STREAMS_MESSAGE_CONSUMERS:
Streams
messaging consumers
iSelfSchooling-SQL> desc DBA_STREAMS_MESSAGE_CONSUMERS;
Name
Null? Type
----------------------------- -------- --------------------
STREAMS_NAME
NOT NULL VARCHAR2(30)
QUEUE_NAME
NOT NULL VARCHAR2(30)
QUEUE_OWNER
NOT NULL VARCHAR2(30)
RULE_SET_NAME
VARCHAR2(30)
RULE_SET_OWNER
VARCHAR2(30)
NEGATIVE_RULE_SET_NAME
VARCHAR2(30)
NEGATIVE_RULE_SET_OWNER
VARCHAR2(30)
NOTIFICATION_TYPE
VARCHAR2(9)
NOTIFICATION_ACTION
VARCHAR2(256)
NOTIFICATION_CONTEXT
ANYDATA
DBA_STREAMS_MESSAGE_RULES: Rules for Streams messaging
iSelfSchooling-SQL> desc DBA_STREAMS_MESSAGE_RULES;
Name
Null? Type
-----------------------------
-------- --------------------
STREAMS_NAME
NOT NULL VARCHAR2(30)
STREAMS_TYPE
VARCHAR2(11)
MESSAGE_TYPE_NAME
VARCHAR2(30)
MESSAGE_TYPE_OWNER
VARCHAR2(30)
MESSAGE_RULE_VARIABLE
VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_CONDITION
VARCHAR2(4000)
|