Re: multiple instances or databases

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Wed, 9 Dec 98 20:10:26 +0200
Message-ID: <ABIqhRsK42@protasov.kiev.ua>

Hi,

If you do not want to use private synonyms then you can try alter session set current_schema. Here is a sample:

SVRMGR> connect viewer/viewer
Connected.
SVRMGR> drop table test;
Statement processed.

SVRMGR> create table test
     2> (id integer
     3> );

Statement processed.
SVRMGR> grant select,insert on test to tester; Statement processed.
SVRMGR> connect tester/tester
Connected.
SVRMGR> insert into test(id) values(1); insert into test(id) values(1)

            *
ORA-00942: table or view does not exist SVRMGR> alter session set current_schema=viewer; Statement processed.
SVRMGR> insert into test(id) values(1); 1 row processed.
SVRMGR> insert into test(id) values(2); 1 row processed.
SVRMGR> insert into test(id) values(3); 1 row processed.
SVRMGR> select * from test;
ID

---

         1
         2
         3

3 rows selected.

You can work with object without prefixing it with owner name.

Andrew Protasov

> 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 - 12:10:26 CST