-
Hi all,
I am trying to insert data in comma delimited file into Oracle database sitting in Unix server. After I ran the script, I got error message as,
Ora8_Acct: sqlload scott/tigger /export/home/dbase/cat.ctl
SQL*Loader: Release 8.0.4.0.0 - Production on Wed Apr 25 13:30:44 2001
(c) Copyright 1997 Oracle Corporation. All rights reserved.
SQL*Loader-930: Error parsing insert statement for column CATEG.CDATE.
ORA-00984: column not allowed here
Control file - cat.ctl
load data
infile '/export/home/dbase/cat.dat'
append
into table categ
fields terminated by "," optionally enclosed by '"'
(cat_id,lis_id,catnme,desct,ptid,stname,mdate "MM/DD/YY",
ordpt,cdate "MM/DD/YY")
Data File - cat.dat
"1","1","Antennas/Base Station Equipment","","","ACTIVE","2/2/01","1","1/18/01"
"2","1","Cable","","","ACTIVE","1/24/01","1","1/18/01"
"3","1","Call and Voice Equipment and Systems","","","ACTIVE","1/24/01","1","1/18/01"
I looked up the error codes, and check the data structure, still couldn't resolve it. Can anyone give me suggestions?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|