GoldenGate: Initialization when Table has Clob
I have been testing Goldengate and I have performed schema initialization successfully when
all tables have scalar data types.
I have a problem when I include a table with a clob column in this test.
My clob table is simply:
desc johns_clob
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
MYCLOB CLOB
I've loaded the clob column with a character string that is 30000 characters long.
When I try to start the initial load, I get the following information in my ggserr.log file and the
process abends:
2010-11-10 16:47:40 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 10.143.204.77 (START EXTRACT INITLOAD ).
2010-11-10 16:47:40 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT INITLOAD starting.
2010-11-10 16:47:40 INFO OGG-01017 Oracle GoldenGate Capture for Oracle, initload.prm: Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.
2010-11-10 16:47:40 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, initload.prm: EXTRACT INITLOAD starting.
2010-11-10 16:47:41 ERROR OGG-01192 Oracle GoldenGate Capture for Oracle, initload.prm: Trying to use RMTTASK on data types which may be written as LOB chunks (Table: 'JOHNB.JOHNS_CLOB').
2010-11-10 16:47:41 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, initload.prm: PROCESS ABENDING.
Trying to use RMTTASK on data types which may be written as LOB chunks
I cannot find any reference to the message "Trying to use RMTTASK on data types which may be written as LOB chunks".
Any help is appreciated.
Thanks,
John