Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Expertise Required with Sql-Loader
I have a file(lobfile.001) which consist of lobdata and another
file(loblocator.txt) which consist
of byte position for each lob in lobfile.001
Contents of lobfile.001 is:
start1 UNIT TESTING A STORED PROCEDURE Unit Testing a Stored Procedure
invovles these five steps:
Content of loblocator.txt is:
"lobfile.001.0.1047148/"
"lobfile.001.1047148.1047148/"
In loblocator, lobfile.001 specifies the lobfile name and "0.1047148"
specifies the byte position
for the lobs in that file i.e the record starts at 0 position byte till
the 104718 byte.
I want to import these lobs using their byte position into Oracle table
columns using sqlloader
Does anyone know the exact way of doing this through sqlloader.
Note: The lobfile.001 contains several lobrecords without any
delimiters. The only way to
differentiate these records from each other is the byte position
specified by the loblocator.txt
Any help will be appreciated.
TIA
Received on Fri Oct 14 2005 - 01:45:28 CDT