OGG-01038 Cannot fetch required data from table
hello i have the following error
OGG-01038 Cannot fetch required data from table SIEBEL.S_EVT_MAIL due to missing key columns.
here is my extract policy
EXTRACT ext3
setenv NLS_LANG=AMERICAN_AMERICA.AL32UTF8
USERID ggs_owner, PASSWORD *******
TRANLOGOPTIONS ALTARCHIVELOGDEST primary instance SBPRD1 /oraarch1/SBPRD, ALTARCHIVELOGDEST primary instance SBPRD2 /oraarch2/SBPRD
FETCHOPTIONS FETCHPKUPDATECOLS
DBOPTIONS ALLOWUNUSEDCOLUMN
RMTHOST i**********, MGRPORT 7809
RMTTRAIL /home/oracle/MIGRATE_SBPRD_ACFS/ggs/dirdat/ss
DISCARDFILE discard.txt, APPEND
DDL INCLUDE ALL
TABLE IT.*;
TABLE SIEBEL.S_EVT_MAIL,KEYCOLS(ROW_ID);
TABLE SIEBEL.*;
TABLE APDBA.*;
TABLE EXECUTOR.*;
TABLE FORTHNOVA.*;
TABLE MIGRATOR.*;
TABLE REPORTER.*;
thanks a lot
Edited by: user1165357 on Nov 24, 2011 1:06 PM
Edited by: user1165357 on Nov 24, 2011 1:07 PM