Linked Oracle Database????

[Rizla]

I have linked my SQL Server to an Oracle database, I can see all of the tables and views, but i cannot open them!! I only have the options 'Copy' and 'Help' when i right click on a table.

i can see/do everything when i log in through Oracle but cant through SQL Server.

Helllllpp

 

[Rosko]

I'm sure your linked db connection has been set up correctly as you can see the tables of your linked server.
I only have the copy and help too. So this is the way I use my linked DB.

select * from openquery ( DBLINK ,'select * from TABLE')

Hope this helps
GL

Rosko

 

[Rizla]

Worked perfectly.

Cheers

 

[sguslan]

Also try "SELECT * FROM DBLINK..OWNERID.TABLENAME"

Note the 2 dots between the dblink name and the table owner name...