API and Internal Commands

CREATE SERVICE process_name

DELETE SERVICE process_name

ENGINE CLEAR SCN

ENGINE DDL_CHECK ddlopid ddltext

ENGINE DUMP ALL

ENGINE DUMP MEMORY_ACCOUNTING

Each allocation point (=malloc call in C code) has it’s own id and this is equal to error code that is raised if the malloc fails – so refer to error code list to find out where is the memory allocated.

ENGINE DUMP MESSAGES

ENGINE ENCRYPT string

ENGINE LOCK RELEASE ALL

ENGINE LOCK RELEASE LOCKS

ENGINE LOCK {TABLES|SCHEMAS} list of tables

ENGINE MINE RESET TO PLOG sequence

ENGINE PREPARE_DP SETUP CLEAR

ENGINE PREPARE_DP WRITE DP_NETWORKLINK

DIRECTORY directory FILE file 

DBLINK dblink 

USERID user/pass@db

ENGINE PREPARE_DP WRITE DP_EXP

DIRECTORY directory FILE file 

MINE_USERID user/pass@db APPLY_USERID user/pass@db

ENGINE PREPARE_DP WRITE EXP FILE file MINE_USERID

user/pass@db APPLY_USERID user/pass@db

ENGINE PREPARE_DP WRITE DDL_FILE FILE file USERID user/pass@db

ENGINE SETUP {MINE|APPLY} CREATE DICTIONARY

ENGINE SETUP {MINE|APPLY} LOAD DICTIONARY

ENGINE SETUP {MINE|APPLY} DROP DICTIONARY

ENGINE SETUP MINE DELETE DICTIONARY

ENGINE SETUP PAIR MINE AND APPLY

ENGINE SUPPLEMENTAL LOGGING SCHEMA 

schema {ENABLE|DISABLE} PRIMARY KEY

Enables/disables supplemental logging on all table in the schema for their primary key. This is mandatory on source for replicate tables. (This is done automatically by PREPARE commands.)

It is also mandatory to enable supplemental logging at database level. This is done automatically during ENGINE SETUP MINE LOAD DICTIONARY.

ENGINE SUPPLEMENTAL LOGGING TABLE  schema.table_name {ENABLE|DISABLE} PRIMARY KEY

Enables/disables supplemental logging on table for its primary key. This is mandatory on source for replicate tables. (This is done automatically by PREPARE commands.)

It is also mandatory to enable supplemental logging at database level. This is done automatically during ENGINE SETUP MINE LOAD DICTIONARY.

ENGINE SWITCH_REDOLOG

START SERVICE process_name

PROCESS CLEAR SCN

PROCESS DUMP ALL

PROCESS DUMP MEMORY_ACCOUNTING

Each allocation point (=malloc call in C code) has it’s own id and this is equal to error code that is raised if the malloc fails – so refer to error code list to find out where is the memory allocated.

PROCESS DUMP MESSAGES

PROCESS ENCRYPT string

PROCESS LOCK RELEASE ALL

PROCESS LOCK RELEASE LOCKS

PROCESS LOCK {TABLES|SCHEMAS} list of tables

PROCESS MINE RESET TO PLOG sequence

PROCESS PREPARE_DP SETUP CLEAR

PROCESS PREPARE_DP WRITE DP_NETWORKLINK

DIRECTORY directory FILE file 

DBLINK dblink 

USERID user/pass@db

PROCESS PREPARE_DP WRITE DP_EXP

DIRECTORY directory FILE file 

MINE_USERID user/pass@db APPLY_USERID user/pass@db

PROCESS PREPARE_DP WRITE EXP FILE file MINE_USERID

user/pass@db APPLY_USERID user/pass@db

PROCESS PREPARE_DP WRITE DDL_FILE FILE file USERID user/pass@db

PROCESS SETUP {MINE|APPLY} CREATE DICTIONARY

PROCESS SETUP {MINE|APPLY} LOAD DICTIONARY

PROCESS SETUP {MINE|APPLY} DROP DICTIONARY

PROCESS SETUP MINE DELETE DICTIONARY

PROCESS SETUP PAIR MINE AND APPLY

PROCESS SUPPLEMENTAL LOGGING SCHEMA 

schema {ENABLE|DISABLE} PRIMARY KEY

Enables/disables supplemental logging on all table in the schema for their primary key. This is mandatory on source for replicate tables. (This is done automatically by PREPARE commands.)

It is also mandatory to enable supplemental logging at database level. This is done automatically during PROCESS SETUP MINE LOAD DICTIONARY.

PROCESS SUPPLEMENTAL LOGGING TABLE  schema.table_name {ENABLE|DISABLE} PRIMARY KEY

Enables/disables supplemental logging on table for its primary key. This is mandatory on source for replicate tables. (This is done automatically by PREPARE commands.)

It is also mandatory to enable supplemental logging at database level. This is done automatically during PROCESS SETUP MINE LOAD DICTIONARY.

PROCESS SWITCH_REDOLOG