SQL*Loader

[Ola Kesh]

Hello,
i just installed oracle 10g and i seems not to locate where to or how to invoke the SQL*Loader. Please, kindly help out.

[Carol Enderlin]

Are you looking for sqlldr in bin diectory?

[Ola Kesh]

Hello,
Am trying to transfer a set of data in the excel spread sheet(which has being converted to "Text (Tab delimited)" format) into my database table.
Read that i have to use a SQL LOADER, which i taught is a script that comes with oracle intallation.
Please help

[Jeanne Boyarsky]

Keshinro,
Right. SQL Loader is a script located in Oracle's bin directory. (Carol provided the name.) Assuming you installed the Oracle database and not just the client of course.

[Ola Kesh]

Hello,
Thanks, am okay now.

[gino jersey]

can you tell us where you found it.
am having trouble looking for it, too.


I also have SQL Navigator - is there a way to do it there?
Please advise.
Thanks.

[Avi Abrami]

Gino,
Regardless of the platform you are using, you should have an ORACLE_HOME environment variable defined which points to the home directory of the Oracle installation. The "bin" directory -- mentioned earlier in this discussion -- is a subdirectory of ORACLE_HOME, so the full path of the SQL*Loader executable is:

ORACLE_HOME/bin/sqlldr

You can find more information about the ORACLE_HOME variable in the "Oracle Installation Guide" for your platform.

Good Luck,
Avi.