DBLINK to SQLSERVER - how to list tables
I've got a couple of questions about how to use a DBLINK from Oracle (9i) to SQLSERVER2005. The link is created and as long as I know the name of a table in SQLSERVER I can read it from Oracle, but I would like to be able to see what tables exist in SQLSERVER from Oracle. I want to run something like :
select * from all_tables@dblinkname
but whatever I try always comes back empty. Is there anyway I can find all the SQLSERVER tables from Oracle ?
Next question is that my application actually runs on a second Oracle instance. So it news to access the first instance through a link and then access SQLSERVER through another link so something like this :
select * from tablename@firstoraclelink@sqlserverlink
but that doesn't seem valid. Is there a way to use a DBLINK on a remote database ?