| Sqlloader error [message #71001] |
Mon, 26 August 2002 07:04  |
manemang
Messages: 5
Registered: May 2002
|
Junior Member |
|
|
Hi Oracle worshippers,
I come before you today with an error message trying to load data using SQL*LoADER. SQL*Loader-350: Syntax error at line 14. Expecting "," or ")", found "PRICE_ID". PRICE_ID)
^
PRICE_ID is a column in the Customer table. Data type is Varchar2(10).
sqlldr80 userid=vincent/vincent control=customer.ctl direct=true
Help me appease the Oracle so I won't have these error messages. I will offer some chicken to my stomach today for Oracle.
Thanks
|
|
|
|
|
|
| Re: Sqlloader error [message #71019 is a reply to message #71003] |
Tue, 27 August 2002 10:07  |
manemang
Messages: 5
Registered: May 2002
|
Junior Member |
|
|
--Sorry guys. Been too busy...here is my control file.
LOAD DATA
INFILE 'CUSTOMER.dat'
BADFILE 'CUSTOMER.bad'
DISCARDFILE 'customer.dsc'
INTO TABLE CUSTOMER
FIELDS TERMINATED BY ','
(
CUSTOMER_ID,
CUSTOMER_NAME,
CUSTOMER_PHONE,
QUANTITY,
PURCHASE_DATE DATE "MM/DD/YY"
PRICE_ID)
The datafile contains only one record.
|
|
|
|
|
|
| Re: Sqlloader error [message #71040 is a reply to message #71003] |
Thu, 29 August 2002 07:52 |
manemang
Messages: 5
Registered: May 2002
|
Junior Member |
|
|
|
After inserting a comma after purchase_date, I got another error...Expecting column name, found keyword DATE. Removed both date and the date format and it says load complete-logical record count 1. I did a select * from customer and get...... no rows selected. The data shows up in the badfile. Please help
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
