OraFAQ Forum: Server Utilities » SQL Loader Problem

Home » RDBMS Server » Server Utilities » SQL Loader Problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Loader Problem [message #302297]

Mon, 25 February 2008 03:54

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

Report message to a moderator