OraFAQ Forum: Client Tools » Getting Errror in run to SQL* loader in TOAD

Home » Other » Client Tools » Getting Errror in run to SQL* loader in TOAD (Oracle 9i and Taod 7.6)

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

Getting Errror in run to SQL* loader in TOAD [message #390447]

Fri, 06 March 2009 06:05

kajal_bhakat
Messages: 2
Registered: March 2009

Junior Member

Hi Friends ,
I m getting Error In Running SQL* loader in Toad.
Error Msg:-'Message 2100 not found; No message file for product=RDBMS, facility=UL'

I m Using Oracle9i and Toad 7.6

Kindly Suggest ..

Thanx in ADvance
Kajal
Smile

Report message to a moderator

Re: Getting Errror in run to SQL* loader in TOAD [message #390450 is a reply to message #390447]

Fri, 06 March 2009 06:11

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>I m Using Oracle9i and Toad 7.6

Try to use Toad 8

Report message to a moderator

Re: Getting Errror in run to SQL* loader in TOAD [message #390476 is a reply to message #390450]

Fri, 06 March 2009 09:00

kajal_bhakat
Messages: 2
Registered: March 2009

Junior Member

But in the Others system i m able to run the Loader ....the configuration is same

Report message to a moderator

Re: Getting Errror in run to SQL* loader in TOAD [message #390477 is a reply to message #390447]

Fri, 06 March 2009 09:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>.the configuration is same
If this were REALLY true, no error would occur.
Your environments are different.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Getting Errror in run to SQL* loader in TOAD [message #390511 is a reply to message #390477]

Fri, 06 March 2009 14:39

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

Senior Member
Account Moderator

I guess that you would have successfully loaded that file only if you had chosen to run SQL*Loader from the operating system command prompt.

Report message to a moderator

Re: Getting Errror in run to SQL* loader in TOAD [message #390812 is a reply to message #390447]

Mon, 09 March 2009 17:19

andrew again
Messages: 2577
Registered: March 2000

Senior Member

As mentioned, get sql loader working from commanline on that machine to the database you are having trouble loading into.

my guess is that you have more than one Oracle client on your machine. Check to see which one is being used from your Toad new connection window. Also, under Toad options, check the settings to sql loader under Executables.

Report message to a moderator

Previous Topic:	SQL Developer
Next Topic:	How can we remove the substitution from SPOOL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 13:08:03 CDT 2024