Oracle Database Discussions

Hi Guys,

I got generic connectivity set up to a sql server machine with ODBC connection,

I can query the following:


select * from information_schema.tables@mssql;


TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
Client00010006 dbo G_COUNTRY BASE TABLE

how to query this G_COUNTRY table over the database link?

select * from Client00010006.dbo.G_COUNTRY@mssql does not work....

And how to check if i got the permissions on that table on Mickysoft?

Thanks!