Re: Loading data...
From: anacedent <anacedent_at_hotmail.com>
Date: Fri, 28 May 2004 17:21:09 -0700
Message-ID: <WHQtc.7686$oi5.7198_at_fed1read07>
Date: Fri, 28 May 2004 17:21:09 -0700
Message-ID: <WHQtc.7686$oi5.7198_at_fed1read07>
Richard S. Crawford wrote:
> I am having problems loading data into my Oracle 9i database. I've
> tried using SQL Loader but it looks like all of the possible field
> delimiters that could be used -- !, |, ~, ^, etc. -- are already in use
> in some text field or another in my database.
>
> Am I SOL with this?
Not necessarily.
What delimiter character is used in the input file to separate fields?
Can you make the fields fixed length in size?
It should not be too difficult to write some PERL code to load the data
into some staging tables.
HTH & YMMV Received on Sat May 29 2004 - 02:21:09 CEST