Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ynt: Creation of Oracle databases
I would say you can create 5 tablespaces under one oracle instance.
One tablespace hold data from one database in sqlserver. All the
tablespace share
the resource.
You never distinct memory usage between your 5 databases in sqlservers
anyway.
You create one login in sqlserver with permission of accessing
database. if you create 5 oracle databases, you have to create 5 set
of users in each of the database? well... if you use digital
signiture, it might be different story...
Regard,
Ms. DBA
Christine Zhao
postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0106250552.da96e5f_at_posting.google.com>...
> 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 Thu Jun 28 2001 - 17:42:20 CDT