Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Expertise Required with Sql-Loader

Expertise Required with Sql-Loader

From: <pankaj_wolfhunter_at_yahoo.co.in>
Date: 13 Oct 2005 23:45:28 -0700
Message-ID: <1129272328.768762.180450@g14g2000cwa.googlegroups.com>


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:

  1. Define the expected outcomes.

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US