Seeing All Tables on a Linked Oracle Server

  • Hi, I have an Oracle OLE DB as a linked server. Is there a way to see ping the Oracle server to see a list of all tables / views on it? Thanks!

  • Check out sp_tables_ex and sp_columns_ex - I think they will do what you are after

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply