Re: Oracle Schemas for our Informix App

My first post was a little misleading.

Let me apologize and try again.

We currently have, and plan to continue to have three "databases". (Quotes because what was implemented as an Informix database, might, conceivably be an Oracle schema). Currently, they are, for legacy reasons, all running on the same hardware. We recognize the undesirability of this.

We will be using newly purchased Sun hardware for the new Oracle based system. The old Sun box will be available for us to use for a development platform.

So, one of the three databases (development) will be on a separate box. It can thus be patched, etc., separately from the production box.

The production box will host two "databases": the actual production "database", and a second "database" for user beta testing and training.

So, now the question is-- and, again, I apologize for the first post which incorrectly stated we were going to put all three "databases" on a single (production) machine-- whether to use schemas or databases for the two user-related "databases".

In light of Mark's helpful comments, it makes great sense to me to have the development platform quite distinct from the production box. But, I could imagine that the two "databases" on the production box might be acceptably managed as two schemas within the same database (and using a single instance). Seems like then the questions about kernel parms in /etc/system would disappear. (Just a single instance).

Any further comments?

Thank you.

Regards,

DG Received on Thu Jan 20 2005 - 15:48:40 CST