Initial load with LOBs

830536

Hi, i'm trying to do an inital load and I keep getting errors like these:

ERROR OGG-01192 Oracle GoldenGate Capture for Oracle, ext1.prm: Trying to use RMTTASK on data types which may be written as LOB chunks (Table: 'TESTDB.BLOBTABLE').
ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.

The table looks like this:

COLUMN_NAME|DATA_TYPE|NULLABLE|DATA_DEFAULT|COLUMN_ID|COMMENTS
UUID VARCHAR2(32 BYTE) No 1
DESCRIPTION VARCHAR2(2000 BYTE) Yes 2
CONTENT BLOB Yes 3


I've checked and the source database does contain data in the blobtable and both databases have the same tables, so now I have no idea what can be wrong? =/

MikeN

For initial loads with LOBs, use a RMTFILE and a normal replicat. There are a number of things that are not supported with "RmtTask". A "rmtfile" is basically the same format as a 'rmttrail' file, but is specifically for initial loads or other "captured" data that is not a continuous stream. And make sure you do have a newer build of GG (either v11 or a latest 10.4 from the support site).

The 'extract' would look something like this:

ggsci> add extract e1aa, sourceIsTable
ggsci> edit param e1aa
extract e1aa
userid ggs, password ggs
-- either local or remote
-- extFile dirdat/aa, maxFiles 999999, megabytes 100
rmtFile dirdat/aa, maxFiles 999999, megabytes 100
Table myschema1.*;
Table myschema2.*;

Then on the target, use a normal 'replicat' to read the "files".

Note that if the source and target are both oracle, this is not the most efficient way to instantiate the target. Using export/import or backup/restore (or any other mechanism) would usually be preferable.

��-Oracle

This method does not support extraction of LOB or LONG data. As an alternative,use “Loading data from file to Replicat”, rmtfile