ERROR OGG-01296 Error mapping from
959520Dec 26 2012 — edited Dec 27 2012Hi experts
I am getting "OGG-01296 " error when i use COLS or COLSEXCEPT parameters. ## ERROR OGG-00212 Invalid option for MAP: COLS(empno. ##
Could you explain where I have mistaken?
thanks in advance .
same table on both server :+
CREATE TABLE emp (empno NUMBER(4),
ename VARCHAR2(10),
job VARCHAR2(9),
sal NUMBER(7, 2));
On source:+
add extract myload2, tranlog, begin now
add rmttrail /u01/app/gg/dirdat/bb, extract myload2
edit params myload2
EXTRACT myload2
USERID ggs_owner, PASSWORD ggs_owner
RMTHOST host2, MGRPORT 7809
RMTTRAIL /u01/app/gg/dirdat/bb
TABLE scott.emp, COLS(empno, ename);
On target+
EDIT PARAMS ./GLOBALS
GGSCHEMA GGS_OWNER
CHECKPOINTTABLE GGS_OWNER.CHKPTAB
DBLOGIN USERID ggs_owner, PASSWORD ggs_owner
ADD CHECKPOINTTABLE GGS_OWNER.CHKPTAB
Add replicat myload2, exttrail /u01/app/gg/dirdat/bb
edit params myload2
REPLICAT myload2
ASSUMETARGETDEFS
USERID ggs_owner, PASSWORD ggs_owner
MAP scott.emp, TARGET scott.emp;
There are not any key columns