Re: Multiple Schemas vs. Multiple Instances

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 28 Jan 1999 15:45:29 GMT
Message-ID: <36b5857a.11799847@192.86.155.100>

A copy of this was sent to Mike Burden <michael.burden_at_capgemini.co.uk> (if that email address didn't require changing) On Thu, 28 Jan 1999 14:57:35 +0000, you wrote:

>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?

in 8i, yes you can have a 'script' run when a user logs in. In 8i, you can have triggers on database events such as:

as well as when a

create
alter
drop

command is executed.

>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.

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 - 09:45:29 CST