Re: multiple Oracle databases
From: Michael A Rife <mar7363_at_tm0006.lerc.nasa.gov>
Date: 12 Feb 1992 21:51 EST
Message-ID: <12FEB199221511107_at_tm0006.lerc.nasa.gov>
Date: 12 Feb 1992 21:51 EST
Message-ID: <12FEB199221511107_at_tm0006.lerc.nasa.gov>
Maybe instead of creating multiple databases, you could create multiple Oracle accounts. One account for each database you have now. If you have database instance A, then create Oracle account A and place all the tables in database A in Oracle account A. Then your application would run on one database and you do not have to worry about database links. You would run your application under one Oracle account. Through the use of grants, you would grant access to all the other Oracle accounts to get your data. This would make backing up your database easier.
Just a suggestion. Received on Thu Feb 13 1992 - 03:51:00 CET