Access data from a schema lying on a different server
Posted by:
My SQL
Date: November 03, 2010 03:30AM
Hi all,
We are moving some of the schema to a different physical server due to size issue.
Since some of the current queries include joins from different schema which now happen to be on different servers, is it possible to keep the join active by calling the other schema on a different physical server?
For example in SQL you can use the ADO SQL Recordset.
Please let me know hot access data from a schema lying on a different server?
Thank you,
MYSQL_User
Subject
Written By
Posted
Access data from a schema lying on a different server
November 03, 2010 03:30AM
November 04, 2010 01:26PM
November 05, 2010 02:17AM
November 07, 2010 02:18PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.