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