Re: Multiple Schemas vs. Multiple Instances

On Thu, 28 Jan 1999 01:42:43 GMT, tkyte_at_us.oracle.com (Thomas Kyte) wrote:

>A copy of this was sent to granta_at_nospam.student.canberra.edu.au (Fuzzy)
>(if that email address didn't require changing)
>On Wed, 27 Jan 1999 23:05:50 GMT, you wrote:
>
>>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
>>:-)
>
>I entered enhancement request 808932 right now for this... So, its under
>consideration -- call support and tell them you want it.
>
>Thomas Kyte
>tkyte_at_us.oracle.com
>Oracle Service Industries
>Reston, VA USA

Thomas,

Thank you very much! I'll call right now.

Ciao
Fuzzy
:-) Received on Thu Jan 28 1999 - 18:19:34 CST