|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_STREAMS_NEWLY_SUPPORTED: List of tables that are newly supported by
Streams
iSelfSchooling-SQL> desc DBA_STREAMS_NEWLY_SUPPORTED;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
REASON
VARCHAR2(39)
COMPATIBLE
CHAR(4)
DBA_STREAMS_RENAME_COLUMN: Rename column transformations
iSelfSchooling-SQL> desc DBA_STREAMS_RENAME_COLUMN;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
VARCHAR2(30)
RULE_NAME
VARCHAR2(30)
SCHEMA_NAME
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
FROM_COLUMN_NAME
VARCHAR2(4000)
TO_COLUMN_NAME
VARCHAR2(4000)
VALUE_TYPE
VARCHAR2(3)
PRECEDENCE
NUMBER
STEP_NUMBER
NUMBER
DBA_STREAMS_RENAME_SCHEMA: Rename schema transformations
iSelfSchooling-SQL> desc DBA_STREAMS_RENAME_SCHEMA;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
VARCHAR2(30)
RULE_NAME
VARCHAR2(30)
FROM_SCHEMA_NAME
VARCHAR2(30)
TO_SCHEMA_NAME
VARCHAR2(30)
PRECEDENCE
NUMBER
STEP_NUMBER
NUMBER
DBA_STREAMS_RENAME_TABLE: Rename table transformations
iSelfSchooling-SQL> desc DBA_STREAMS_RENAME_TABLE;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
VARCHAR2(30)
RULE_NAME
VARCHAR2(30)
FROM_SCHEMA_NAME
VARCHAR2(30)
TO_SCHEMA_NAME
VARCHAR2(30)
FROM_TABLE_NAME
VARCHAR2(30)
TO_TABLE_NAME
VARCHAR2(30)
PRECEDENCE
NUMBER
STEP_NUMBER
NUMBER
DBA_STREAMS_RULES: Rules used by Streams processes
iSelfSchooling-SQL> desc DBA_STREAMS_RULES;
Name
Null? Type
----------------------------- -------- --------------------
STREAMS_TYPE
VARCHAR2(11)
STREAMS_NAME
VARCHAR2(30)
RULE_SET_OWNER VARCHAR2(30)
RULE_SET_NAME
VARCHAR2(30)
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
RULE_CONDITION
CLOB
RULE_SET_TYPE CHAR(8)
STREAMS_RULE_TYPE
VARCHAR2(6)
SCHEMA_NAME
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
SUBSETTING_OPERATION
VARCHAR2(6)
DML_CONDITION
VARCHAR2(4000)
INCLUDE_TAGGED_LCR
VARCHAR2(3)
SOURCE_DATABASE
VARCHAR2(128)
RULE_TYPE
VARCHAR2(3)
MESSAGE_TYPE_OWNER
VARCHAR2(30)
MESSAGE_TYPE_NAME
VARCHAR2(30)
MESSAGE_RULE_VARIABLE
VARCHAR2(30)
ORIGINAL_RULE_CONDITION
VARCHAR2(4000)
SAME_RULE_CONDITION
VARCHAR2(3)
DBA_STREAMS_SCHEMA_RULES: Schema rules created by streams administrative
APIs
iSelfSchooling-SQL> desc DBA_STREAMS_SCHEMA_RULES;
Name
Null? Type
----------------------------- -------- --------------------
STREAMS_NAME
VARCHAR2(30)
STREAMS_TYPE
VARCHAR2(11)
SCHEMA_NAME
VARCHAR2(30)
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_TABLE_RULES: Table rules created by streams administrative
APIs
iSelfSchooling-SQL> desc DBA_STREAMS_TABLE_RULES;
Name
Null? Type
----------------------------- -------- --------------------
STREAMS_NAME
VARCHAR2(30)
STREAMS_TYPE
VARCHAR2(11)
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
RULE_TYPE
VARCHAR2(7)
DML_CONDITION
VARCHAR2(4000)
SUBSETTING_OPERATION
VARCHAR2(6)
INCLUDE_TAGGED_LCR
VARCHAR2(3)
SOURCE_DATABASE
VARCHAR2(128)
RULE_NAME
VARCHAR2(30)
RULE_OWNER
VARCHAR2(30)
RULE_CONDITION
VARCHAR2(4000)
DBA_STREAMS_TRANSFORMATIONS: Transformations defined on rules
iSelfSchooling-SQL> desc DBA_STREAMS_TRANSFORMATIONS;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
VARCHAR2(30)
RULE_NAME
VARCHAR2(30)
TRANSFORM_TYPE
VARCHAR2(26)
FROM_SCHEMA_NAME
VARCHAR2(30)
TO_SCHEMA_NAME
VARCHAR2(30)
FROM_TABLE_NAME
VARCHAR2(30)
TO_TABLE_NAME
VARCHAR2(30)
SCHEMA_NAME
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
FROM_COLUMN_NAME
VARCHAR2(4000)
TO_COLUMN_NAME
VARCHAR2(4000)
COLUMN_NAME
VARCHAR2(4000)
COLUMN_VALUE
ANYDATA
COLUMN_TYPE
VARCHAR2(4000)
COLUMN_FUNCTION
VARCHAR2(30)
VALUE_TYPE
VARCHAR2(3)
USER_FUNCTION_NAME
VARCHAR2(4000)
SUBSETTING_OPERATION
VARCHAR2(6)
DML_CONDITION
VARCHAR2(4000)
DECLARATIVE_TYPE
VARCHAR2(13)
PRECEDENCE
NUMBER
STEP_NUMBER
NUMBER
DBA_STREAMS_TRANSFORM_FUNCTION:
Rules-based
transform functions used by Streams
iSelfSchooling-SQL> desc DBA_STREAMS_TRANSFORM_FUNCTION;
Name
Null?
Type
----------------------------- -------- --------------------
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
VALUE_TYPE
VARCHAR2(4000)
TRANSFORM_FUNCTION_NAME
VARCHAR2(4000)
CUSTOM_TYPE
VARCHAR2(11)
DBA_STREAMS_UNSUPPORTED: List of all the tables that are not supported by
Streams in this release
iSelfSchooling-SQL> desc DBA_STREAMS_UNSUPPORTED;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
REASON
VARCHAR2(39)
AUTO_FILTERED
VARCHAR2(3)
DBA_SUBPARTITION_TEMPLATES
iSelfSchooling-SQL> desc DBA_SUBPARTITION_TEMPLATES;
Name
Null? Type
----------------------------- -------- --------------------
USER_NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
SUBPARTITION_NAME
NOT NULL VARCHAR2(34)
SUBPARTITION_POSITION
NUMBER
TABLESPACE_NAME
VARCHAR2(30)
HIGH_BOUND
LONG
DBA_SUBPART_COL_STATISTICS
iSelfSchooling-SQL> desc DBA_SUBPART_COL_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL
VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
SUBPARTITION_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
NUM_DISTINCT
NUMBER
LOW_VALUE
RAW(32)
HIGH_VALUE
RAW(32)
DENSITY
NUMBER
NUM_NULLS
NUMBER
NUM_BUCKETS
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
AVG_COL_LEN
NUMBER
HISTOGRAM
VARCHAR2(15)
DBA_SUBPART_HISTOGRAMS
iSelfSchooling-SQL> desc DBA_SUBPART_HISTOGRAMS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
SUBPARTITION_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
BUCKET_NUMBER
NUMBER
ENDPOINT_VALUE
NUMBER
ENDPOINT_ACTUAL_VALUE
VARCHAR2(1000)
DBA_SUBPART_KEY_COLUMNS
iSelfSchooling-SQL> desc DBA_SUBPART_KEY_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
NAME
VARCHAR2(30)
OBJECT_TYPE
CHAR(5)
COLUMN_NAME |