| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple Schemas vs. Multiple Instances
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
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Jan 27 1999 - 19:42:43 CST
 |
 |