May 17, 2011 at 5:42 am
Hi
I have a linked server (linked to an oracle schema) and i want to add a table that exists in the oracle schema to the linked server.
Does anyone know how?
Thanks in advance
May 17, 2011 at 5:44 am
I don't think you need to do anything. If the table exists in the db and the linked server gives you access to the db you should be all set (assuming no permission is missing).
May 17, 2011 at 5:45 am
that is what i thought but the tables available in the sql server linked server are only a selection of the tables from the oracle schema
maybe it is permissions
May 17, 2011 at 5:48 am
The first thing I'd test it to access ANY table or object on that linked server. That will tell you if there's a problem with connection or db access. From there on out it's just a matter of having the correct table name and making sure you have permissisons.
One test (not permanent setup) is to use sa (whatever they call it in Oracle). That should grant you access to the table. If that fails you know you have another problem on your hands.
May 17, 2011 at 7:17 am
it was the permissions mate thanks
in oracle i had to assign permissions to the user that was accessing the linked server for each of the tables that i needed
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply