Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ynt: Creation of Oracle databases
Murat YILDIZ wrote:
> 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
If the person that asked the question comes from a Microsoft-centric version of the database world ... to them the phrase "multiple databases" means the same to someone schooled in Oracle as the phrase "multiple schemas."
Daniel A. Morgan Received on Mon Jun 25 2001 - 15:25:01 CDT