Home » RDBMS Server » Server Utilities » SQLLOADER:Truncate Data B4 import
SQLLOADER:Truncate Data B4 import [message #74148] Mon, 20 September 2004 07:10 Go to next message
K Rajesh
Messages: 6
Registered: February 2002
Junior Member
Hi,

I have around 20 SQLLOADER import Daily jobs which need 20 tables to be truncated before import.

Is there any way, or command I can write in ctl file which will delete data from table before import ?

 

Thanks

A

Report message to a moderator

Re: SQLLOADER:Truncate Data B4 import [message #74151 is a reply to message #74148] Mon, 20 September 2004 16:14 Go to previous message
Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA
Senior Member
You can use REPLACE or TRUNCATE, before your INTO TABLE.

Report message to a moderator

Previous Topic: problem in importing files
Next Topic: Export terminated successfully without warnings.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 27 12:32:18 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.