PDA

View Full Version : Where do I find the SQL Loader tool?


Paul
03-25-2005, 06:15 AM
Hi all,

I have downloaded 9.2.0.1.0 of Oracle and am currently trying it out.
In these groups I see refererences to SQLLoader.

Where do I find this tool? I have looked in the various Oracle
directories, but cannot find it!



Paul...


--

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

if Oracle group then
db := Oracle 9.2.0.1.0;
else
db := Interbase 6.0.2.0;
endif

As a courtesy to those who spend
time analyzing and attempting to
help, please do not top post.

GreyBeard
03-25-2005, 06:20 AM
On Fri, 25 Mar 2005 14:15:11 +0000, Paul wrote:
Hi all, I have downloaded 9.2.0.1.0 of Oracle and am currently trying it out. In these groups I see refererences to SQLLoader. Where do I find this tool? I have looked in the various Oracle directories, but cannot find it!

Check the %ORACLE_HOME%\bin directory for executables with the string
'load' in the name.

Paul
03-25-2005, 09:03 AM
GreyBeard <Fuzzy.GreyBeard@gmail.com> wrote:
Where do I find this tool? I have looked in the various Oracle directories, but cannot find it!

Check the %ORACLE_HOME%\bin directory for executables with the string'load' in the name.


I have these two files

ctxload.exe & loadpsp.exe

but no sign of anything like SQLLoader.exe - is it the second file?


Paul...


--

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

if Oracle group then
db := Oracle 9.2.0.1.0;
else
db := Interbase 6.0.2.0;
endif

As a courtesy to those who spend
time analyzing and attempting to
help, please do not top post.

Sybrand Bakker
03-25-2005, 09:09 AM
On Fri, 25 Mar 2005 17:03:46 +0000, Paul <paulsnewsgroups@hotmail.com>
wrote:
I have these two filesctxload.exe & loadpsp.exebut no sign of anything like SQLLoader.exe - is it the second file?Paul...

Iirc it is called sqlldr.exe, and you must have either installed the
server software or the administrator client. Ordinary user will
exclude sqlldr and imp and exp.


--
Sybrand Bakker, Senior Oracle DBA

Paul
03-25-2005, 11:15 AM
Sybrand Bakker <gooiditweg@nospam.demon.nl> wrote:

but no sign of anything like SQLLoader.exe - is it the second file?

Iirc it is called sqlldr.exe, and you must have either installed theserver software or the administrator client. Ordinary user willexclude sqlldr and imp and exp.


Got it thanks - I have the Enterprise version installed.



Paul...


--

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

if Oracle group then
db := Oracle 9.2.0.1.0;
else
db := Interbase 6.0.2.0;
endif

As a courtesy to those who spend
time analyzing and attempting to
help, please do not top post.

GreyBeard
03-25-2005, 12:54 PM
On Fri, 25 Mar 2005 18:09:56 +0100, Sybrand Bakker wrote:
sqlldr.exe

Doh! Brain's been elsewhere. Sorry to OP for misdirection.


MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service