This discussion is archived
1 Reply Latest reply: Mar 28, 2013 10:12 AM by Raj_OGG-Oracle RSS

initial load failed to transfer the clob data

SANCHITGUPTA Newbie
Currently Being Moderated
Hi Experts

I am trying to move my huge database from Window 10g to 11g on linux though Goldengate Initial Laod. It have clob, long, blob datatypes. When i tring to move thought below parameters its giving an error

Error:
The Trail file can not be used with specialrun parameter and when i create a normal replicate process to replicate the data its dissplaying an error for log_csn, log_xid and log_cmplt_csnl columns under ggs_checkpointable (unable to populate this columns)




--Loading data from file to Replicat (Transfer Method)

Source Database Server:

1. EDIT PARAMS load1

2. Add below parameter into parameter files with name load1

SOURCEISTABLE
USERID gguser@orcl, PASSWORD test
RMTHOST 10.8.18.189, MGRPORT 7810
RMTFILE /ora01/initialload/pt, MAXFILES 10000, MEGABYTES 10
TABLE test.*;

3. EDIT PARAMS load2

4. Add below parameter into parameter files with name load2

SPECIALRUN
USERID gguser@orcl1, PASSWORD test
EXTTRAIL/ora01/initialload/pt
ASSUMETARGETDEFS
MAP test.*, TARGET test.*;
END RUNTIME

5. Start the extract porcess on the source database:

cmd> ogg_directory > extract paramfile dirprm\load1.prm reportfile c:\load1.rpt

6. Start the replicat process on the target Database Server:

$ ogg_directory> replicat paramfile dirprm/load2.prm reportfile /ora01/load1.rptt

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points