Re: Weird "CURRENT_SCHEMA" behavior
From: Mladen Gogala <no_at_email.here.invalid>
Date: Wed, 4 Nov 2009 18:36:40 +0000 (UTC)
Message-ID: <pan.2009.11.04.18.36.39_at_email.here.invalid>
On Wed, 04 Nov 2009 19:07:29 +0100, Maxim Demenko wrote:
>
>
> I observed the same behaviour in 8i and 9i databases as well. Maybe,
> this is expected behaviour?
>
> ;-)
>
> Best regards
>
> Maxim
Date: Wed, 4 Nov 2009 18:36:40 +0000 (UTC)
Message-ID: <pan.2009.11.04.18.36.39_at_email.here.invalid>
On Wed, 04 Nov 2009 19:07:29 +0100, Maxim Demenko wrote:
> Mladen Gogala wrote:
>> The "ALTER SESSION SET CURRENT_SCHEMA" used to only influence the name >> resolution. In version 10.2, it also influences the owner of the newly >> created objects:
>
>> This is strange! I observed the same behavior in 11.2 database.
>
> I observed the same behaviour in 8i and 9i databases as well. Maybe,
> this is expected behaviour?
>
> ;-)
>
> Best regards
>
> Maxim
I can't point to the article, but I do remember reading that it should only change the name resolution. I also tested it on a 9i database and it works as above. This is, apparently, the expected behavior.
-- http://mgogala.freehostia.comReceived on Wed Nov 04 2009 - 12:36:40 CST