Home » Infrastructure » Unix » Not able to use sqlldr (Solaris )
icon8.gif  Not able to use sqlldr [message #461454] Fri, 18 June 2010 02:27 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 19474
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.
Re: Not able to use sqlldr [message #461488 is a reply to message #461454] Fri, 18 June 2010 05:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
export ORACLE_HOME=/YOUR_ORACLE_HOME
export PATH=$PATH:$ORACLE_HOME/bin
Re: Not able to use sqlldr [message #461489 is a reply to message #461462] Fri, 18 June 2010 05:38 Go to previous messageGo to next message
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
Re: Not able to use sqlldr [message #461497 is a reply to message #461489] Fri, 18 June 2010 05:53 Go to previous message
methomasjoe
Messages: 3
Registered: June 2010
Junior Member
Thanks guys I was able to do it !!!
Previous Topic: Needed Script to export Yesterday partition.
Next Topic: how to escape $ in the package name called from shell script
Goto Forum:
  


Current Time: Thu Aug 21 11:57:40 CDT 2014

Total time taken to generate the page: 0.09843 seconds