Home » RDBMS Server » Server Utilities » delete previous n add new data
delete previous n add new data [message #69439] Mon, 07 January 2002 17:16 Go to next message
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 "&#124" OPTIONALLY ENCLOSED BY '"'
( DB_NAME,
NOTES,
CREATE_DATE,
SYSTEM)
Re: delete previous n add new data [message #69440 is a reply to message #69439] Mon, 07 January 2002 18:06 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
LOAD DATA
INFILE 'C:dataadmin.expsdd____100.unl'
BADFILE 'C:loaderadmin5.bad'

replace INTO TABLE SDD

FIELDS TERMINATED BY "&#124" OPTIONALLY ENCLOSED BY '"'
( DB_NAME,
NOTES,
CREATE_DATE,
SYSTEM)
Previous Topic: Re: oracle dba papers
Next Topic: sql loader
Goto Forum:
  


Current Time: Sat Mar 02 12:58:52 CST 2024