RE: SQLLDR using Direct=True with Multiple Physical Records

From: Mason, Tara <>
Date: Fri, 25 Jan 2008 10:56:54 -0600
Message-ID: <>


Yes, I am going to use the exp/imp to load the data into test. But still wanted to see if there was any way to load this type of data using sqlldr with direct=true - for future reference.

There are multiple physical records because the linesize is not long enough when the data is dumped. This particular table has many varchar columns.


Tara Mason
Database Administrator
(847) 468-3028
TARA.MASON_at_SAFETY-KLEEN.COM -----Original Message-----
From: Jeremiah Wilton [] Sent: Friday, January 25, 2008 10:45 AM
To: Mason, Tara;
Subject: RE: SQLLDR using Direct=True with Multiple Physical Records

Mason, Tara wrote:

> I need to move data from a production table to the test table.
> I would like to use sqlldr with DIRECT=TRUE

Are you moving all rows or a subset of rows? If you are moving all rows then you should consider exp/imp instead of sqlplus/sqlldr.

> 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?


Jeremiah Wilton
ORA-600 Consulting

Received on Fri Jan 25 2008 - 10:56:54 CST

Original text of this message