Location of SQL*Loader required [message #199701] |
Wed, 25 October 2006 21:36 |
islandfong
Messages: 2 Registered: September 2006 Location: Singapore
|
Junior Member |
|
|
I am using TOAD8.5.3 connecting to Oracle10g. I use the SQL*LOADER to import data from dat/CSV file to Oracle database. I follow the procedures as:
1. Select DBA -> SQL*Loader Wizard
2. Click Next and specify input files.
3. Click Add to add an input file.
4. Set the Record format as Stream and CLick Ok.
5. Click Next and select the destination table name.
6. Type a comma (,) in the All Fields Delimited by. (A drop down)
7. Click Next and specify the location of a control file name.
8. Click Save Settings to save the settings.
8. Click Next and select Execute Now with Watch Process.
9. Click Finish to execute.
Then I get the following error "Location of SQL*Loader required".
Can somebody tell me what's wrong with my procedure or any problem with my SQL*LOADER?
|
|
|