I am in the process of migrating data from db2 to oracle.
I exported data using db2export LOBSINFILE so I can get it in one file.
This created a lob file with name test.001.lob
.dat file in this format
name1, cpms_obj_type.001.lob.0.69/, type
name2, cpms_obj_type.001.lob.69.101/, type2
name3, cpms_obj_type.001.lob.170.18/, type2
The format of an LLS is filename.ext.nnn.mmm/, where filename.ext is the name of the file that contains the LOB, nnn is the offset in bytes of the LOB within the file, and mmm is the length of the LOB in bytes.
I am trying to load this using the sqlldr but I can't figure out how to specify that the .dat contains filename in the nnn.mmm?
Please provide an example.
Control file
load data
infile 'data\test.dat'
truncate
into table oTest
trailing nullcols
(
NAME CHAR(255),
DESCRIP_ref FILLER,
DESCRIP LOBFILE(DESCRIP_ref) TERMINATED BY EOF,
type char(255)
)
I am getting file not found error.
I know if I have a separate file for each lob it works fine but I want it one lob file.
I am trying to load this using the sqlldr but I can't figure out how to specify that the .dat contains filename in the nnn.mmm?
Please provide an example.