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. This command should not be used. Users should use the DUMP MINE/APPLY MEMORY_ACCOUNTING command.

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

example: ENGINE PREPARE_DP WRITE DDL_FILE FILE test_ddl.sql USERID demo/demo@demosrc

Write data load script – ddl create (just DDL, so it actually does not load the data).

• file will be the name of the file created.
• user/pass@db (source database schema/password@sourcedb)

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 MINE SCHEMA schema MINE_DDL

• YES
• NO 

ENGINE SETUP MINE TABLE schema.table MINE_DDL

• YES
• NO 

ENGINE SETUP MINE SCHEMA schema MINE_PLSQL

• YES
• NO 

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

ENGINE TEST_CONNECTION_ORACLE

user/pass@db 

ENGINE TEST_CONNECTION_ORACLE_AS_SYSDBA

user/pass@db as SYSDBA

ENGINE RESYNC COUNTERS FOR TABLE schema.table {OFFLINE}

START SERVICE process_name

PROCESS CLEAR SCN

PROCESS DDL_CHECK ddlopid ddltext

PROCESS DUMP ALL

run as:

DUMP FETCHER|MINE|APPLY ALL

PROCESS DUMP MEMORY_ACCOUNTING

run as:

DUMP FETCHER|MINE|APPLY 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

run as:
DUMP FETCHER|MINE|APPLY 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 MINE SCHEMA schema MINE_DDL

• YES
• NO 

PROCESS SETUP MINE TABLE schema.table MINE_DDL

• YES
• NO 

PROCESS SETUP MINE SCHEMA schema MINE_PLSQL

• YES
• NO 

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

PROCESS TEST_CONNECTION_ORACLE

user/pass@db 

PROCESS TEST_CONNECTION_ORACLE_AS_SYSDBA

user/pass@db AS SYSDBA

PROCESS RESYNC COUNTERS FOR TABLE schema.table {OFFLINE}