SQL*Loader and Multiple Instances on a Server 2

[THoey]

I have created two different instances of a database on one server. Both instances have a user created with several objects (same user name). How can I specify whichinstance I want to load the data into? Terry M. Hoey

 

[carp]

Don't you have to provide a tns alias to indicate which instance you want to log into? You would use the same tns aliases to start your sql*loader run.

 

[THoey]

You are correct. I tried it before, but it came down to I had a problem with server. Rebooted and then did the following:

SQLLDR login/password@instance controlfilename

But thanks for the mental kick Carp... Terry M. Hoey

 

[JHoarty]

I think maybe this is what you mean? I put this at the top of my ctl file and copy and paste it (minus the "--&quot into my dos window (by right-clicking on the window's title bar and choosing "paste&quot

-- sqlldr73 username/password@sid control=E:\path\file.ctl log=E:\path\file.log

The username/password@sid indicates which instance.

Hope this is what you were after.
John Hoarty
jhoarty@quickestore.com

http://www.quickestore.com

 

[rcurva]

or, you can set or export ORACLE_SID to the instance of your preference.

if you have a Unix backend, include in your script the following line. Better approach is to parameterize the sid:

export ORACLE_SID=$sid1

...

sqlldr user/pwd controlfile

Just an idea...