Re: Creating a database

Paul Taylor wrote:
>
> 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

Hi,

I can think of two solutions:
1. Have two databases/instances.
2. Have one instance:

   Create the first set of table in one user,export the user, import it    to a new tablespace. create second user as production env.,and create    a second copy of the tables there.

        Hadar Paiss Received on Sat Mar 23 1996 - 00:00:00 CET