Re: Switching between instances

Gertjan,

If your client has been written using Pro*C then you can hold references to more than one database. Call several "exec sql connect" statements and then use the "exec sql at <connection name> " syntax for the DML.

Another alternative is to create a view of one database in the other. This can be done using synonyms or views with database links. You then only access one database.

There may be other ways. I have tried these and they both work well enough.

Regards

Gertjan Stil wrote:

> I am working on an application that has two 'databases', one for real
> and one to do exercises. The databases have the same structure and
> will be accessed by the same client application. I intend to make two
> instances on a parallel server.
> I need some information whether it is possible to disconnect from
> one instance and connect to the other one without stopping my client
> application. I am running Oracle7.3 on Windows NT4.
> Can somebody help me?
>
> Thanks in advance,
>
> -- Gertjan Stil
> _____________________________________________________________________________
> J.G. Stil, Informatics Division, National Aerospace Laboratory (NLR) |
> Phone : +31 20 5113428 | Anthony Fokkerweg 2 | P.O. Box 90502 |
> /
> Fax : +31 20 5113210 | 1059 CM Amsterdam | 1006 BM Amsterdam |
> (NLR)
> E-mail: stil_at_nlr.nl | ------------ The Netherlands -------------
> | /

--
*************************
Gary Smith
CERN, Geneva, Switzerland
Email: Gary.Smith_at_cern.ch
Tel:   +41 22 7678944
*************************