| SQL*Loader does strange loading, please help!!!! [message #70738] |
Fri, 19 July 2002 05:44  |
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
)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
