Home » RDBMS Server » Server Utilities » SQL*Loader does strange loading, please help!!!!
SQL*Loader does strange loading, please help!!!! [message #70738] Fri, 19 July 2002 05:44 Go to next message
Cristian Diaconu
Messages: 4
Registered: July 2002
Junior Member
Hello,
I'm trying to load some data from a file and the action succedes with the only problem that the database table rows are not in the orders they are in the file from which extracted.

I'm currently using Oracle9i as server and SQL*Loader that comes with it.
The .ctl script is below. If someone could give me a hint I would apreciate it.

Thank you.

".ctl" script follows:

LOAD DATA
INFILE 'e:sharedtest.new' "str '~'"
INSERT
INTO TABLE SCH.TESTTAB
FIELDS TERMINATED BY '~'
(
seg
)
Re: SQL*Loader does strange loading, please help!!!! [message #70739 is a reply to message #70738] Fri, 19 July 2002 06:33 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. try using direct path.
2. truncte the target table before using sql*loader.
Previous Topic: Create Database Link
Next Topic: Re: New sqlldr user having problems loading date column
Goto Forum:
  


Current Time: Mon Dec 23 07:22:44 CST 2024