Replicat abends with ORA-01407 with NULL values. ¿Expected behaviour?
Hello,
I'm currently testing this setup:
create table USRGG.tabla1 (id number not null, campo2 number not null, campo3 number);
..
add trandata USRGG.tabla1, COLS(id), NOKEY
..
Extract LGGATE
Table USRGG.*;
.....
Extract PGGATE
PassThru
RmtHost rmt-vip, MgrPort 7840, TCPBUFSIZE 100000, COMPRESS
RmtTrail dirdat/R9
Table USRGG.*;
....
Replicat RGGATE
AssumeTargetDefs
Map USRGG."TABLA1", Target USRGG."TABLA1", KEYCOLS (id);
Map USRGG.*, Target USRGG.*;
... (on source)
insert into USRGG.tabla1 values (1,11,111);
commit;
update USRGG.tabla1
set campo3=555 where id = 1;
commit;
... (on target, replicat abends)
MAP resolved (entry USRGG.TABLA1):
Map "USRGG"."TABLA1", Target USRGG."TABLA1", KEYCOLS (ID);
2014-03-13 21:33:33 WARNING OGG-00869 No unique key is defined for table 'TABLA1'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.