Re: Help! How do I create a second database on the same machine?

Jeremy Cope wrote:
>
> I have an Oracle 7.3 database running on NT and I would like to create
> two environments e.g test and prod
>
> What is the best way to do this?
>
> Do I need to install Oracle again and create another instance and
> database?
>
> Can I use the same instance for two databases? (I don't think so)
>
> Thanks in advance
>
> Jeremy Cope
> Consultant and desperado..........

The best way to do this is to set the environmental variable ORACLE_SID different first. Then edit the old CREATE DATABASE scripts, to reflect new database files, their sizes and location. Run the scripts.
A totally new database will be created with the same ORACLE HOME. You should not ahve to do anything with the old database. To access the two databases, each time you will have to set the environmental variable ORACLE_SID. Amit Received on Thu Jul 03 1997 - 00:00:00 CDT