Re: Please Help with an *Advanced* question. Thanks.

Yes, you certainly can create another instance, and this is the correct way of solving your problem.

I can't give you detailed instructions, since I've never done it on NT, but it wasn't too difficult on Unix

If you read through the "getting started" guide which came with your Oracle CD, you should find instructions in there. I've had a quick browse, and it seems that there are a number of different ways of doing, but using the Instance Manager seems like the easiest (maybe someone could confirm this?)

Hope that helps,

Dean

In article <60pk0l$r2p_at_examiner.concentric.net>,   Nnoor_at_cris.com (NNOOR) wrote:
>
>
> The time has come for our project to move forward and have us
> developers coexist with the users. That means that the database
> and schema will be used by the users and we can't "play" with it
> anymore. But devlopment requirements are otherwise. We have to have
> a "play" version of the same schema. We are stuck with hardcoding
> the schema name in the application (e.g. we don't say Select * from
> aTable, rather select * from schema.aTable, etc etc). Since we can't
> have the same schema name twice in a database, what we gotta have is
> another database (an instance?) for developers only and leave the
> "live" data alone. The problem is that I don't have a clue as to how
> to implement a brand new database (an instance) and have it running
> on the same NT server (along with the "live" oracle DB server). Do I
> have to install Oracle a 2nd time in a new directory, if so, will it's
> "services" happily co-exist with the other (live) instance? Or what?
> Please pardon my ignorance. I know I am asking for a lot of information
> here, but I will appreciate even the direction towards the right set of
> documentation.
>
> Thank yo uall for all your help!!!
>
> Regards,
> Nasir (nnoor_at_cris.com)

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet