Re: Multiple Schemas vs. Multiple Instances

This seems good (and yes, I will contact Oracle support) but we need a bit more.

Why can't default settings like this be attached to a userid, or better still, can you force a script to run when an ID logs on so these can be set manually? The problem is I have no wish to embed this code in my app. I shouldn't need to. This also applies to other session parameters like setting sql trace on. I know one can set the trace on for an active session but sometimes the session is in and out before you get a chance. Other times you have a pool of sessions and your not sure which one the app will use. Also it may not be your code to allow the alter session to be embedded.

A PL/SQL script that executes at logon time would be great and would solve these problems and others without changing the alter user command.

Of course if we can do this now or soon then, please, someone enlighten me.

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
>
> --
> http://govt.us.oracle.com/ -- downloadable utilities
>
> ----------------------------------------------------------------------------
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
>
> 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 Thu Jan 28 1999 - 08:57:35 CST