SQL Loader and Date Conversions?

Hello everyone,

I am currently trying to load a dat file in to oracle that has a multiple date field in it here is a piece of it.

1         apr 01 1998 00:00:000210371658          1
1         apr 01 1998 00:00:000646658333          5
1         apr 01 1998 00:00:001074546000          4

I have seen lots of code examples that show how to dates that don't have any spaces in between, but nothing that like my dat above. Below is the table that I created to take the dat.

SQL> create table daily_sales (
  2 amount_ordered char(2),
  3 purchase_date date,
  4 product_id char(12),
  5 act_type char(1));

Table created.

Then I went and created the control file shown below.

SQL> create table daily_sales (
  2 amount_ordered char(2),
  3 purchase_date date,
  4 product_id char(12),
  5 act_type char(1));

Table created.

When i try to run the load I get the error message.

SQL*Loader-350: Syntax error at line 5.
Expecting valid column specification, "," or ")", found "postion". purchase_date postion (11:21) date 'mmm dd yyyy',

Thanks for the help

Liam

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 01 2000 - 00:00:00 CST