Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Question Using Synonyms
> Connect mary/password_at_mydatabase
> SELECT * from TestJohn;
> Oops : table does not exist...
> ALTER SESSION SET CURRENT_SCHEMA=John;
> SELECT * from TestJohn;
> Hey ; It works...
I use this all the time. Quite handy.
I heard, at least at one point, that this was an unsupported feature.