Re: Multiple Schemas vs. Multiple Instances

From: Fuzzy <granta_at_nospam.student.canberra.edu.au>
Date: Wed, 27 Jan 1999 23:05:50 GMT
Message-ID: <36af9986.4376561@newshost.interact.net.au>

On Wed, 27 Jan 1999 18:28:31 GMT, garysadler_at_my-dejanews.com wrote:

>Since posting my original message, I discovered the undocumented feature of
>ALTER SESSION which allows default schema prefixing:
>
>ALTER SESSION SET CURRENT_SCHEMA=<whatever>
>
>This feature is unsupported, but supposedly in heavy use by imp/exp. Whether
>that makes me feel any better about banking on it, I'm not sure just yet.

Does anyone know if Oracle has plans to support this? It could make my life SO much easier, it's not funny.

Ciao
Fuzzy
:-) Received on Wed Jan 27 1999 - 17:05:50 CST