Re: Oracle Schemas for our Informix App

David E. Grove wrote:

> We are redeveloping our Informix app in Oracle.
>
> The app has 3 identical databases (production, test, and development) in a
> single Informix instance (Informix sense of "instance"). Each database has
> 1000 tables and 1000 stored procedures.
>
> Since Oracle connects to only a single database at a time, to avoid having
> to use multiple instances (Oracle sense of "instance") of Oracle, we could,
> for each of the current databases, just use distinct Oracle Schemas within a
> single Oracle database. Does this sound reasonable? The system catalog
> for the single database with three schemas would then have 6000 tables and
> stored procedures, plus (guessing) another 6000, or more, indexes, since
> each table has at least one index.
>
> I suppose the alternative is to run three separate instances of Oracle, to
> connect to three separate databases.
>
> I'm at the view from a 100,000 feet stage. :-)
>
> Thanks for any thoughts.
>
> Regards,
>
> DG

Everyone else's responses to you have been good so I don't want to repeat what has been said but there is one thing I would suggest you look at ... 1000 stored procedures, in Oracle, should be condensed down into a dozen or so packages for many reasons both practical and technical. Be sure you read up on packages.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---