Skip to Main Content
  • Questions

  • Linked Server from Sql Server to Oracle

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, carmilla.

Asked: October 11, 2012 - 3:38 pm UTC

Last updated: October 11, 2012 - 5:11 pm UTC

Version: oracle 10.2.0

Viewed 1000+ times

You Asked

I have created a linked server on my SQL Server 2012 instance (OS windows 2008 ) to my oracle 10.2.0 instance. Is there any way to retrict the schemas showing up when you expand catalog under linked server in SMSS?


and Tom said...

I don't know what SMSS is, but I presume it is a tool that is just querying ALL_USERS at the remote site - so no, there wouldn't be in that case a way to limit it.

You'd probably have to ask the makers of the SMSS tool if they can filter that information.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

carmilla brinkley, October 11, 2012 - 3:55 pm UTC

SSMS stands for sql server management studio
Tom Kyte
October 11, 2012 - 5:11 pm UTC

that is fine, it is a client tool that would have to perform any and all filtering. You would have to ask the makers of SMSS if they can do that. They are just querying the data dictionary.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.