Re: Q on concepts of instances and mutliple databases on the same server

Simon Goland wrote:
>
> So right now I have a Oracle instance running the "real" database. Can I
> have another instance running my "dummy" on the same machine at the same
> time, with its own datafiles, tablespaces and stuff, or do I have to
> shutdown the "real" thing and then create and configure and play with
> the "dummy"? And shut the real one down every time I need to play with
> the dummy?

  You can create as many as instances you want unless your machine and operating system can afford it.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841