| regardding sqlldr [message #159614] |
Mon, 20 February 2006 10:55  |
nag_ravi
Messages: 1
Registered: February 2006
Location: London
|
Junior Member |
|
|
in oracle database one table is there with some data. after that i have a csv file with data it contains what ever data in the table + new data.
now i generate control file and executed through sqlldr. this will work or not?
it inserts the new data into the existing table or not?
if already existing data is modified in the csv. i.e., updated in the existing table or not?
if not send a example and ctrl file to update the existing data.
regards
ravi shankar
|
|
|
|
| Re: regardding sqlldr [message #159624 is a reply to message #159614] |
Mon, 20 February 2006 11:28  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
sqlldr by default will only append.
It cannot update.
you can truncate the data in table ( or just backup using CTAS).
Load the csv
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
