Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ynt: Creation of Oracle databases
No,
One instance manages one database only. One database can be managed by multiple instances though in Oracle Parallel Server only. This is the cornerstone of the Oracle architecture.
Regards,
Sybrand Bakker, Oracle DBA
"Murat YILDIZ" <myildiz_at_bellona.com.tr> wrote in message news:<9h734p$c7n49$1_at_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 - 08:52:55 CDT