ALL_REPRESOL_STATS_CONTROL: Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user

iSelfSchooling-SQL> desc ALL_REPRESOL_STATS_CONTROL;

Name Null? Type

----------------------------- -------- --------------------

SNAME NOT NULL VARCHAR2(30)

ONAME NOT NULL VARCHAR2(30)

CREATED NOT NULL DATE

STATUS VARCHAR2(9)

STATUS_UPDATE_DATE NOT NULL DATE

PURGED_DATE DATE

LAST_PURGE_START_DATE DATE

LAST_PURGE_END_DATE DATE

ALL_REPSCHEMA: N-way replication information

iSelfSchooling-SQL> desc ALL_REPSCHEMA;

Name Null? Type

----------------------------- -------- --------------------

SNAME NOT NULL VARCHAR2(30)

DBLINK NOT NULL VARCHAR2(128)

MASTERDEF VARCHAR2(1)

SNAPMASTER VARCHAR2(1)

MASTER_COMMENT VARCHAR2(80)

GNAME NOT NULL VARCHAR2(30)

MASTER VARCHAR2(1)

GROUP_OWNER NOT NULL VARCHAR2(30)

ALL_REPSITES: N-way replication information

iSelfSchooling-SQL> desc ALL_REPSITES;

Name Null? Type

----------------------------- -------- --------------------

GNAME NOT NULL VARCHAR2(30)

DBLINK NOT NULL VARCHAR2(128)

MASTERDEF VARCHAR2(1)

SNAPMASTER VARCHAR2(1)

MASTER_COMMENT VARCHAR2(80)

MASTER VARCHAR2(1)

GROUP_OWNER NOT NULL VARCHAR2(30)

ALL_REWRITE_EQUIVALENCES: Description of all rewrite equivalence accessible to the user

iSelfSchooling-SQL> desc ALL_REWRITE_EQUIVALENCES;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

NAME NOT NULL VARCHAR2(30)

SOURCE_STMT CLOB

DESTINATION_STMT CLOB

REWRITE_MODE VARCHAR2(10)

ALL_RULES: Rules seen by the user

iSelfSchooling-SQL> desc ALL_RULES;

Name Null? Type

----------------------------- -------- --------------------

RULE_OWNER NOT NULL VARCHAR2(30)

RULE_NAME NOT NULL VARCHAR2(30)

RULE_CONDITION CLOB

RULE_EVALUATION_CONTEXT_OWNER VARCHAR2(30)

RULE_EVALUATION_CONTEXT_NAME VARCHAR2(30)

RULE_ACTION_CONTEXT RE$NV_LIST

RULE_COMMENT VARCHAR2(4000)

ALL_RULESETS: Rule sets seen by the user: maintained for backward compatibility

iSelfSchooling-SQL> desc ALL_RULESETS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

RULESET_NAME NOT NULL VARCHAR2(30)

RULESET_STORAGE_TABLE VARCHAR2

BASE_TABLE VARCHAR2(61)

RULESET_COMMENT VARCHAR2(4000)

ALL_RULE_SETS: Rule sets seen by the user

iSelfSchooling-SQL> desc ALL_RULE_SETS;

Name Null? Type

----------------------------- -------- --------------------

RULE_SET_OWNER NOT NULL VARCHAR2(30)

RULE_SET_NAME NOT NULL VARCHAR2(30)

RULE_SET_EVAL_CONTEXT_OWNER VARCHAR2(30)

RULE_SET_EVAL_CONTEXT_NAME VARCHAR2(30)

RULE_SET_COMMENT VARCHAR2(4000)

ALL_RULE_SET_RULES: Rules in all rule sets seen by the user

iSelfSchooling-SQL> desc ALL_RULE_SET_RULES;

Name Null? Type

----------------------------- -------- --------------------

RULE_SET_OWNER NOT NULL VARCHAR2(30)

RULE_SET_NAME NOT NULL VARCHAR2(30)

RULE_OWNER NOT NULL VARCHAR2(30)

RULE_NAME NOT NULL VARCHAR2(30)

RULE_SET_RULE_ENABLED VARCHAR2(8)

RULE_SET_RULE_EVAL_CTX_OWNER VARCHAR2(30)

RULE_SET_RULE_EVAL_CTX_NAME VARCHAR2(30)

RULE_SET_RULE_COMMENT VARCHAR2(4000)

ALL_SCHEDULER_CHAINS: All scheduler chains in the database visible to current user

iSelfSchooling-SQL> desc ALL_SCHEDULER_CHAINS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

CHAIN_NAME NOT NULL VARCHAR2(30)

RULE_SET_OWNER VARCHAR2(30)

RULE_SET_NAME VARCHAR2(30)

NUMBER_OF_RULES NUMBER

NUMBER_OF_STEPS NUMBER

ENABLED VARCHAR2(5)

EVALUATION_INTERVAL INTERVAL DAY(3) TO

SECOND(0)

USER_RULE_SET VARCHAR2(5)

COMMENTS VARCHAR2(240)

ALL_SCHEDULER_CHAIN_RULES: All rules from scheduler chains visible to the current user

iSelfSchooling-SQL> desc ALL_SCHEDULER_CHAIN_RULES;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

CHAIN_NAME NOT NULL VARCHAR2(30)

RULE_OWNER NOT NULL VARCHAR2(30)

RULE_NAME VARCHAR2(30)

CONDITION VARCHAR2(4000)

ACTION VARCHAR2(4000)

COMMENTS VARCHAR2(4000)

ALL_SCHEDULER_CHAIN_STEPS: All steps of scheduler chains visible to the current user

iSelfSchooling-SQL> desc ALL_SCHEDULER_CHAIN_STEPS;

Name Null? Type

----------------------------- -------- --------------------

OWNER NOT NULL VARCHAR2(30)

CHAIN_NAME NOT NULL VARCHAR2(30)

STEP_NAME NOT NULL VARCHAR2(30)

PROGRAM_OWNER VARCHAR2(98)

PROGRAM_NAME VARCHAR2(98)

EVENT_SCHEDULE_OWNER VARCHAR2(98)

EVENT_SCHEDULE_NAME VARCHAR2(98)

EVENT_QUEUE_OWNER VARCHAR2(30)

EVENT_QUEUE_NAME VARCHAR2(30)

EVENT_QUEUE_AGENT VARCHAR2(30)

EVENT_CONDITION VARCHAR2(4000)

SKIP VARCHAR2(5)

PAUSE VARCHAR2(5)

RESTART_ON_RECOVERY VARCHAR2(5)

STEP_TYPE VARCHAR2(14)

TIMEOUT INTERVAL DAY(3)TO SECOND(0)

ALL_SCHEDULER_GLOBAL_ATTRIBUTE: All scheduler global attributes

iSelfSchooling-SQL> desc ALL_SCHEDULER_GLOBAL_ATTRIBUTE;

Name Null? Type