0

I have an SQL Server 2008 Express Edition and added an Oracle DB as a linked server with the OraOLEDB.Oracle provider. The connection works but I can only see the views from the Oracle server, no tables, and no materialized views.

I can SELECT * on the visible views, so there doesn't seem to be an obvious problem with the linking.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
alexkelbo
  • 724
  • 6
  • 18
  • 2
    if you connect to Oracle (directly, not through SQL Server) with the same user as SQL Sever uses to connect to Oracle, can you select from the Materialized Views? – moleboy Jun 20 '12 at 14:40
  • Yes, when I connect through PL/SQL Developer I can see all the tables and materialized views. – alexkelbo Jun 21 '12 at 07:07

1 Answers1

0

Problem solved: I was looking for the tables and materialized views in SQL Management Studio in the Object Explorer tree, which only showed me the "normal" views. I opened the Object Explorer Details view (F7) and there they all were: tables and views. The materialized views are also displayed under tables.

alexkelbo
  • 724
  • 6
  • 18