Re: Two databases

Well, from a backup and recovery standpoint it would be easier to backup just one. The question is are these applications 3rd party applications or in-house developed. Keep in mind that both applications would need to be compatible with future upgrades of Oracle at the same time if they are in one database. In my opinion, if you don't have a compelling reason to seperate them, like the one mentioned above, then why would you want split them? If it is feasable to put them together then you might be able to take better use of your drives if they were combined for the sake of the archive files and redo logs.

Just a thought!

Ghengis Khan wrote in message
<01bd266e$925d7ba0$df0452c2_at_Janzeb.stockport.ac.uk>...
>I hope someone can help me with this.
>
>I have two completely seperate applications, they do not share any data nor
>are they likely to in the forseeable future.
>
>The applications are not big enough to run on a server of their own. So
>they will be running on one server.
>
>The question is: Should I create two seperate instances and run two
>databases or should I have one database and just use two seperate
>tablespaces?
>
>I was going to create two seperate DBs but read an Oracle book which
>suggests it may be better to use one DB and seperate the application data.
>
>Thanks in advance.
>
>Reagrds
>
>JK
>
>
Received on Sat Jan 24 1998 - 00:00:00 CET