multiple instances or databases

Hello

I have the following problem to deal with

we have a NT 4.0 server with oracle 7.3.4 on it and 1 database with 1 instance with development tool Delphi

Our policy to do all the development on that specific server, so all the projects are located on that server.

One project has the following environments :

• development
• testing
• final testing

It must be possible that project x can retrieve tables from project y without qualifying the object owner.

I seperated thes environments through 3 tablespaces I cannot make public synonyms now, because each table occurs 3 times; you could solve it via private synonyms, but that is a hell of a job. If i made in stead of 3 tablespaces, 3 instances under 1 database, could i use then the public synonym ?
Or is it mandatory to make 3 databases as well? Who has an acceptable solution for me

Thanks
gkor_at_rdw.nl Received on Wed Dec 09 1998 - 09:38:04 CST