MASTER TABLE:
CREATE TABLE TEST.MY_TABLE
( COL1 NUMBER(10),
COL2 VARCHAR2 (5 BYTE),
COL3 VARCHAR2 (5 BYTE))
...
CREATE UNIQUE INDEX TEST.UI_MY_TABLE ON TEST.MY_TABLE(COL1)
...
TARGET TABLE:
CREATE TABLE TEST.MY_TABLE
( COL1 NUMBER(10),
COL2 VARCHAR2 (5 BYTE),
COL3 VARCHAR2 (5 BYTE),
ID NUMBER(10) Generated as Identity (START WITH 1 MAXVALUE 9999999999 MINVALUE 1 NOCYCLE CACHE 20 NOORDER NOKEEP))
...
CREATE UNIQUE INDEX TEST.UI1_MY_TABLE ON TEST.MY_TABLE(COL1)
CREATE UNIQUE INDEX TEST.UI2_MY_TABLE ON TEST.MY_TABLE (ID)
...
Extract:
extract extra1
exttrail ...
setenv ...
useridalias ...
GETUPDATEBEFORES
GETTRUNCATES
SOURCECATALOG ...
table TEST.MY_TABLE;
Pump:
extract pump1
rmthost ...
rmttrail ...
passthru
table *.*;
Replicat:
replicat repli1
useridalias ...
GETUPDATEBEFORES
GETTRUNCATES
HandleCollisions
--assumetargetdefs
--map *.*, target *.*;
map TEST.MY_TABLE, target TEST.MY_TABLE, COLMAP (USEDEFAULTS, ID = ??????)
i tried a lot... i'm always getting "Error in COLMAP clause" or "Key column ID is missing from map".
Any idea how can i do this?
Thanks in advance.