I want to configure initial load in from file to replicate mode
My configuration:
Initex.prm file :
SOURCEISTABLE
USERIDALIAS ROOTDB
SQLLOADER
RMTHOST localhost, MGRPORT 7809
RMTFILE ./dirdat/initld.dat, MEGABYTES 2, PURGE
SOURCECATALOG SOURCE_DB
TABLE SRC.TBL1;
initrepl.prm file:
SPECIALRUN
END RUNTIME
GENLOADFILES sqlldr.tpl
USERIDALIAS TRGDB
EXTFILE ./dirdat/initld.dat
ASSUMETARGETDEFS
MAP SOURCE_DB.SRC.TBL1, TARGET TRG.TRG_TBL1;
Then i have registed this files:
> ADD EXTRACT INITEX, SOURCEISTABLE
> ADD REPLICAT INITREPL, SPECIALRUN
After start initial process i have error:
ERROR OGG-02979 Invalid checkpoint configuration on SOURCEISTABLE initial load Extract.
How to fix it ?