Re: Creating a database

> Paul Taylor <ptaylor_at_pia.bt.co.uk> writes:
> Does anyone out there know of the best method to run two databases
> concurrently, using one for the evelopment of our sofware whilst the
> other is kept for the current release of software that we are using?
>
> Due to the software we inherited the pro-c has the tablespace hard
> coded, so it is not a simple case of creating a new tablespace within
> the database.
>
> If possible I would like to have both data bases running at the same
> time, but I suspect that I will have to shut one down and start the
> other up if I am to use the same hard code.
>
>
> Any ideas??
>
>
> Paul Taylor
>

>>>>
If your hardware / OS won't support two concurrently open instances, another alternative is to make one Oracle userid the owner of the tables of each "logical" database. The tables can then have the same names for each database, qualified by the ownerid. And they can share the same tablespace if that's what you need. This will require that userids other than the owner of a logical databae qualify their table references. However, you could use private synonyms to achieve this without changing programs; a SQL script creating synonyms for the appropriate environment would let you switch a userid between development and test. Received on Tue Mar 26 1996 - 00:00:00 CET