This is another case of LOB loading, in this case the BLOB data type is used to store binary data. When loading records from the same data file, there is an overhead involved to find out the record length. Loading from a secondary data file is more suitable for loading LOB data. When loading LOB data this way there is no requirement that the LOB field fits in memory, the load takes place by reading from the LOB file in 64K chunks.
When loading data from a LOB file, there are two ways to specify the LOB file; it can be specified either statically or dynamically. In the first case, the file is specified in the same control file. In the case of a dynamically defined LOB file, the file is specified within the data file and it is read into a FILLER
field (from the datafile) which is then used as a parameter in the control file to specify where the LOB file is.
A FILLER
field acts as a place holder; it is not read as actual data, its position is just considered in the data...