OraFAQ Forum: Server Utilities » Error using sql Loader

Home » RDBMS Server » Server Utilities » Error using sql Loader

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

Error using sql Loader [message #73284]

Tue, 16 March 2004 21:18

Rajeev Katyal
Messages: 55
Registered: April 2002

Member

I am having following table named emp1
with following colums
test@DTCS.WORLD>desc emp1
Name Null? Type
------------------------------- -------- ----
NO NUMBER(4)
NAME VARCHAR2(10)
----------------------------------------------

I wish to insert data in this table using sqlldr

----------------------------------------------

following are the contents of my data file (Named c:1.dat)

7839,KING

7698,BLAKE
7782,CLARK
7566,JONES
7654,MARTIN
-----------------------------------------------

so have written control file as ( named c:c1.ctl )

load data
infile 'c:1.dat'
into table emp1
fields terminated by ','
(NO,NAME)

------------------------------------------------

and giving following command

sqlldr80 userid=test/test@dp_lud_test control=c:c1.ctl

But it is not inserting the records and so giving following error

sql*loader-350: syntax error at line 5.
Expecting colum name , found keyword NO
(NO,NAME)
^
Please suggest what's wrong. I am using Oracle 8.0.5 on WinNt

Thanks

Report message to a moderator

Re: Error using sql Loader [message #73290 is a reply to message #73284]

Wed, 17 March 2004 03:51

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

bash-2.03$ sqlldr userid=mag/mag control=c1.ctl

SQL*Loader: Release 9.2.0.4.0 - Production on Wed Mar 17 08:54:36 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 5

bash-2.03$ sqlplus -s mag/mag <<EOF
> select * from emp1;
> exit
> EOF

        NO NAME
---------- ----------
      7839 KING
      7698 BLAKE
      7782 CLARK
      7566 JONES
      7654 MARTIn

bash-2.03$ cat  c1.ctl
load data
infile '1.dat'
into table emp1
fields terminated by ','
(
NO,
NAME
)

Report message to a moderator

Previous Topic:	Want to import 9i data
Next Topic:	sql loader rejects all -ve decimal values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 08:36:50 CST 2025