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 offetc. 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@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?
-- //www.freelists.org/webpage/oracle-l