May 3, 2002 at 11:15 pm
Hi,
I created a linked server to ORACLE server. The ORACLE server had 2 database on it. When the linked server already establish, I can only see tables from one database, and never able to view tables on other database.
I use SQL Server Query Analyzer to establish the linked server. I used MSDAORA as a provider string. As far as I know we cannot specified the catalog name using MSDAORA.
FYI, the database that I can accessed is the first database that created on that ORACLE server.
Does anybody know how to access the other database
Thanks in advance,
Hendra
May 8, 2002 at 5:16 am
Oracle doesn`t have databases. Do you mean 2 Oracle instances? Or database objects under different owner names?
Andy.
May 8, 2002 at 6:59 am
If two instances you will need a second linked server to see the other. If the schema is different then you will need the quailify with FROM schema.tablename for you to access these. Also tables under different schemas do not always show up in EM for some reason.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply