Re: one instance can hv how many database?

[Quoted] In article <91prel$pif$1_at_violet.singnet.com.sg>,   "lkw" <lkw_at_axiomatique.com> wrote:
> hi all,
>
> currently i hv one oracle instance running and one database name DB01
 is
> mounted to it.
> izzit possible to create another database DB02 and mounted to the same
> instance?
> or i need a second instance for the second database DB02? if yes, how
 to run
> the second instance?
>
> thanks. yr help would be greatly appreciated.
>
> lkw.
>
>
It is not possible to have a second database on any instance. (refer to Oracle Concepts)
Yes you need a second instance. However, you probably just want to have different schemas in one database.
As the creation of an instance is platform dependent, you need to refer to your getting started manual as to how to create it.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/