RE: SQLLDR using Direct=True with Multiple Physical Records
Date: Fri, 25 Jan 2008 10:56:54 -0600
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_at_SAFETY-KLEEN.COM -----Original Message-----
From: Jeremiah Wilton [mailto:jeremiah_at_ora-600.net] Sent: Friday, January 25, 2008 10:45 AM
To: Mason, Tara; oracle-l_at_freelists.org
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?