hello, i have done replication.
my configuration:
>ALTER CREDENTIALSTORE ADD USER C##GGADMIN@ORC19 ALIAS ROOTDB
>ALTER CREDENTIALSTORE ADD USER C##GGADMIN@TARGET_DB ALIAS TRGDB
--SOURECE_DB database
create table src.TBL1
( id int
,atr1 varchar2(100)
,atr2 int
,atr3 date
) tablespace storage_src;
CREATE UNIQUE INDEX SRC.UI_TBL1 ON src.TBL1(ID);
ALTER TABLE src.TBL1 ADD constraint PK_TBL1 PRIMARY KEY (ID);
--TARGET_DB database
create table TRG.TRG_TBL1
( id int
,atr1 varchar2(100)
,atr2 int
,atr3 date
) tablespace storage_trg;
CREATE UNIQUE INDEX TRG.UI_TRG_TBL1 ON TRG.TRG_TBL1(ID);
ALTER TABLE TRG.TRG_TBL1 ADD constraint PK_TRG_TBL1 PRIMARY KEY (ID);
created CHECKPOINTTABLE TRG.CHECKTBL
--EXTRACT
EXTRACT EXT2
setenv(TNS_ADMIN=/u01/app/oracle/product/19/db_home/network/admin)
USERIDALIAS ROOTDB
RMTHOST localhost, MGRPORT 7809
RMTTRAIL ./dirdat/ab
SOURCECATALOG SOURCE_DB
TABLE SRC.TBL1;
--REPLICAT
REPLICAT REPL2
setenv(TNS_ADMIN=/u01/app/oracle/product/19/db_home/network/admin)
USERIDALIAS TRGDB
ASSUMETARGETDEFS
SOURCECATALOG SOURCE_DB
MAP SRC.TBL1 TARGET TRG.TRG_TBL1;
> DBLOGIN USERIDALIAS ROOTDB
> add extract EXT2 tranlog begin now
> REGISTER EXTRACT EXT2 DATABASE CONTAINER(SOURCE_DB)
> add extract EXT2 tranlog begin now
> add rmttrail ./dirdat/ab extract ext2
> DBLOGIN USERIDALIAS TRGDB
> add replicat REPL2 EXTTRAIL ./dirdat/ab
ext2 is running
repl2 after start command becomes into ABENDED status with errors:
WARNING OGG-02760 ASSUMETARGETDEFS is ignored because trail file /u01/app/ogg/21/home/dirdat/ab000000000 contains table definitions
INFO OGG-06505 MAP resolved (entry SOURCE_DB.SRC.TBL1): MAP "SOURCE_DB"."SRC"."TBL1" TARGET "TARGET_DB".TRG.TRG_TBL1.
INFO OGG-02756 The definition for table SOURCE_DB.SRC.TBL1 is obtained from the trail file.
INFO OGG-06511 Using following columns in default map by name: ID, ATR1, ATR2, ATR3.
INFO OGG-06510 Using the following key columns for target table TARGET_DB.TRG.TRG_TBL1: ID.
ERROR OGG-01296 Error mapping from SOURCE_DB.SRC.TBL1 to TARGET_DB.TRG.TRG_TBL1
please suggest me to clear this error.