1 Reply Latest reply: Mar 28, 2013 12:12 PM by Raj_OGG-Oracle RSS

    initial load failed to transfer the clob data

    SANCHITGUPTA
      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