Oracle view pulling data from schemas in different instances?
You could create a database link: http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/ds_concepts002.htm#ADMIN12092 and then do
CREATE VIEW MYVIEW AS SELECT X,Y,Z FROM A.MYTABLE UNION SELECT X,Y,Z FROM B.MYTABLE@<LinkName>