delete previous data n load new [message #44] |
Mon, 07 January 2002 17:15 |
tofeks
Messages: 10 Registered: December 2001
|
Junior Member |
|
|
every time WHEN i load data Into database(using sqlloader) i want old datas on that database to be deleated.. How i can do it?
I tried this but it gives error:
LOAD DATA
INFILE 'C:dataadmin.expsdd____100.unl'
BADFILE 'C:loaderadmin5.bad'
DELETE FROM SDD
APPEND INTO TABLE SDD
FIELDS TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"'
( DB_NAME,
NOTES,
CREATE_DATE,
SYSTEM)
|
|
|
Re: delete previous data n load new [message #45 is a reply to message #44] |
Mon, 07 January 2002 18:05 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
use replace option
LOAD DATA
INFILE 'C:dataadmin.expsdd____100.unl'
BADFILE 'C:loaderadmin5.bad'
replace INTO TABLE SDD
FIELDS TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"'
( DB_NAME,
NOTES,
CREATE_DATE,
SYSTEM)
|
|
|