Re: SQLLDR using Direct=True with Multiple Physical Records

From: Bradd Piontek <piontekdd_at_yahoo.com>
Date: Fri, 25 Jan 2008 11:10:39 -0600
Message-ID: <479A180F.4050700@yahoo.com>


Jeremiah brings up a very valid question regarding you formatting.

If it is your lines wrapping due to length, you need to set some sql*plus formatting:
set linesize 4000
set trimspool on
set pagesize 0
set echo off
set feedback off

etc. Hope that helps you with sql*ldr. As other's have mentioned, 8.0.5 - oracle exp/imp or simply a INSERT INTO SELECT * from table_name_at_dblink would do the trick in a much simpler fashion.

Jeremiah Wilton wrote:
>> The problem I have is there are multiple physical records on
>> the file for one row on the table. To retrieve the data from
>> the production side I execute the following SQL statement:
>> SELECT COL1 || ,|| COL2 || , ||, etc. There are many
>> varchar columns on this table; therefore, the number of physical
>> lines can vary.
>>
>
> Are there multiple lines per row because there are CR/LFs embedded in the
> column values, or because the linesize in sqlplus was not long enough when
> you dumped the data?
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 25 2008 - 11:10:39 CST

Original text of this message