Initial Load - can it be impdp data pump?
edited Sep 10, 2012 2:24PM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered
I have setup a oracle to oracle 11.2.0.3.3 environment using Oracle example HR schema to work out the issues.
After initial database was setup, I used datapump to export and import HR schema. When I try to enable replicat process, in the log file I find the following
2012-09-06 14:48:53 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, ggrep_hr.prm: Error mapping from HR.EMPLOYEES to HR.EMPLOYEES.
Can data pump be used for initial loads? Is there a step I am missing? I would like to avoid truncating hr table in the new databases just to be able to use GG initial load process.
After initial database was setup, I used datapump to export and import HR schema. When I try to enable replicat process, in the log file I find the following
2012-09-06 14:48:53 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, ggrep_hr.prm: Error mapping from HR.EMPLOYEES to HR.EMPLOYEES.
Can data pump be used for initial loads? Is there a step I am missing? I would like to avoid truncating hr table in the new databases just to be able to use GG initial load process.
0