Home » RDBMS Server » Server Utilities » SQL Loader Problem
SQL Loader Problem [message #302297] Mon, 25 February 2008 03:54 Go to next message
mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore
Member
In sqlldr every time i have to delete the table. then only it is allowing me to insert the new records. Is there any method to insert the records without deleting the table.

loader1.ctl
-----------

load data
infile 'c:datamydata.csv'
into table emp2
fields terminated by "," optionally enclosed by '"'
( empno, empname, sal, deptno )



thank you in advance
Muthu
Re: SQL Loader Problem [message #302302 is a reply to message #302297] Mon, 25 February 2008 04:04 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use APPEND keyword.

Regards
Michel
Previous Topic: Exp\Imp from one pc to another pc
Next Topic: Error while taking the backup of table containing blob database
Goto Forum:
  


Current Time: Sun Dec 04 12:41:08 CST 2016

Total time taken to generate the page: 0.08231 seconds