Ynt: Creation of Oracle databases

From: Murat YILDIZ <myildiz_at_bellona.com.tr>
Date: Mon, 25 Jun 2001 13:19:24 +0300
Message-ID: <9h734p$c7n49$1@ID-82167.news.dfncis.de>

orahelp <chachaji_at_vayumail.com> wrote in message news:d192fbb2.0106242004.822186a_at_posting.google.com...
> If your mysql database is not very huge then you might want to create
> only one database and only one instance in oracle and then move data
> from all the 5 database to only one oracle database.
>
> else if you want to keep every thing seprate then yes, you need to
> create
> 5 database and 5 instance in oracle.

Apart from this thread, isn't it possible to create more than one database within an instance?So that multiple databases uses the same Database resources?

Murat

>
> orahelp
>
>
>
> m.fangtao_at_genesis.co.nz (Meng) wrote in message
news:<1ddc56b5.0106241842.2a112f31_at_posting.google.com>...
> > Hi,
> > We will migrate Mysql to Oracle soon. Now I have a question. We have
> > 5 databases in one instance in Mysql. Do we need to create 5 databases
> > in Oracle, or only one? We have to start 5 instances and assign
> > different sizes of RAM to them If we create 5 databases. Thanks in
> > advance.
> >
> > Meng
Received on Mon Jun 25 2001 - 05:19:24 CDT