I'm new to this forum and quite new to Oracle/SQL.
I have Oracle Home edition setup at home and I'm trying to load the Orders table from the MS Access Northwind table into a table I created in Oracle.
I have successfully loaded the Customers table. I setup all the fields as they were in MS Access for the Orders table but I'm having problems loading it into Oracle. SQL Loader runs and it says something about committ but when I check the Orders table in Oracle the information is not there. I think it's something to do with dates because I can load other fields in the Orders table successfully.
The dates in the CVS file are in the format DD/MM/YYYY and the dates field in Oracle as defined as DATE. I've searched all over the Internet but still can't figure this out. Solutions to this problem will be well appreciated.
Thanks for the solution- it worked perfect. However, I'm now stuck with trying to load the 'Freight' column.
In Oracle I have defined the datatype as float for 'Freight' because it is in decimal places in the csv file, for example £23.56. However, same as before with the dates it is not loading. The control file entry for 'Freight' is:
Freight DECIMAL EXTERNAL,
I know I've probably made a mistake somewhere. I'm new to this SQL Loader. Any help appreciated.