multiple oracle databases

From: <skipevans_at_my-dejanews.com>
Date: Mon, 05 Oct 1998 19:26:41 GMT
Message-ID: <6vb6hg$iel$1@nnrp1.dejanews.com>

I am trying to implement multiple oracle databases in a C/Unix environment. I have two problems to solve:

In the current application we export environment variables for USER, PASSWORD, SID, and INSTANCE. What would I have to export to access tables in two different databases?
In the sql code embedded in my C program, how do I specify which database a table resides in? What is the syntax for such a call?

Thanks so much to anyone who can help with this! I'm in dire need of this info! Please respond to: sevans_at_solbright.com

Sincerely,

Skip Evans

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 05 1998 - 14:26:41 CDT