Home » RDBMS Server » Server Utilities » SQL Loader Problem
SQL Loader Problem [message #302297] Mon, 25 February 2008 03:54 Go to next message
Messages: 64
Registered: May 2005
Location: Bangalore
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.


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

thank you in advance
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: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use APPEND keyword.

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 Oct 23 03:39:03 CDT 2016

Total time taken to generate the page: 0.08298 seconds