multiple Oracle databases

I'm creating several databases here in support of a particular application and I'm distributing my tables among these databases in order to group them in some meaningful manner.

My question has to with the fact that all of these tables will be used by the application. My plan is, quite naturally, to create DATABASE LINKs from one of the databases into each of the other databases. In this manner I can connect to this primary database and have access to all tables. A suggestion was made that perhaps a better way to handle this situation is to create another database which will have in it nothing but DATABASE LINKs into the other databases. In this way any of my databases can be closed, without loosing the ability to access all of the others.

This strategy sounds a bit bizarre, but it also makes a lot of sense to me.

What do you think?

-- 


--------------------------------------------------------------------------------

Robin McEntire			 | Internet: robin_at_prc.unisys.com
Paramax/Paoli Research Center	 |


--------------------------------------------------------------------------------