Toad World® Forums

Importing using SQL Loader for Oracle Toad

I getting an error 500 the application does not finds the source file (.dat or .txt) while executing the wizard…
what Im doing wrong… do I need to grant permission to the directory so Toad can access the source file?

QLLoader-500: Unable to open file (C:\xxx\xxxxxx\AppData\Roaming\Quest Software\Toad for Oracle\10.6\2012-2013.dat) I have try other locations but it won’t find it.
SQL
Loader-555: unrecognized processing option
SQL*Loader-509: System error: The operation completed successfully.

SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

Does it work if you put the file in a folder that has a short path with no spaces?