OraFAQ Forum: Unix » Not able to use sqlldr

Home » Infrastructure » Unix » Not able to use sqlldr (Solaris )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Not able to use sqlldr [message #461454]

Fri, 18 June 2010 02:27

methomasjoe
Messages: 3
Registered: June 2010

Junior Member

Hi All,

I am not able to use the sqlldr installed on my remote unix box. I know the oracle path and the sqlldr file is present in the bin folder of oracle home.

Could any one please help in setting up all the environment variables for using sqlldr. Iam getting the foollowing error while running the sqlldr command

Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facility=UL

Regards
Thomas Joe

[Updated on: Fri, 18 June 2010 02:29]

Report message to a moderator

Re: Not able to use sqlldr [message #461462 is a reply to message #461454]

Fri, 18 June 2010 02:59

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

On a remote computer? Why don't you use SQL*Loader on your own computer? This is its advantage - you don't have to have access to a server (which you would have to if you, for example, wanted to use external tables), but do everything on your own.

Report message to a moderator

Re: Not able to use sqlldr [message #461488 is a reply to message #461454]

Fri, 18 June 2010 05:37

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

export ORACLE_HOME=/YOUR_ORACLE_HOME
export PATH=$PATH:$ORACLE_HOME/bin

Report message to a moderator

Re: Not able to use sqlldr [message #461489 is a reply to message #461462]

Fri, 18 June 2010 05:38

methomasjoe
Messages: 3
Registered: June 2010

Junior Member

Hi,

Here is my scenario.

I have a more than 5000 files total size around 100GB in a unix server, where I have an account. I have put these files into the Oracle BLOB table. I am trying to run the sqlldr in the unix server where I am getting the above error.

I can not copy the files to my local as its not recommended.

Regards
Thomas

Report message to a moderator

Re: Not able to use sqlldr [message #461497 is a reply to message #461489]

Fri, 18 June 2010 05:53

methomasjoe
Messages: 3
Registered: June 2010

Junior Member

Thanks guys I was able to do it !!!

Report message to a moderator

Previous Topic:	Needed Script to export Yesterday partition.
Next Topic:	how to escape $ in the package name called from shell script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 09:59:27 CST 2024