Re: Sharing Tables with Multiple Instances

You can create a public database link on one instance pointing to the table owner on the other instance. Then you can access any table by using the database link name or you can create synonyms for each table on the instance that doesn't contain the database link. Lets say table 'A' resides on instance ABCD and you are on instances DEFG. Create a public database link say OTHER with owner and password and connect string to Instance ABCD. Then if you want to access table A you would say SELECT * from A_at_OTHER. You could create a synonym called 'A' for A_at_OTHER; then all you need is SELECT * from A. Hope this helps.

jlroberts Received on Thu May 09 1996 - 00:00:00 CEST