Re: Weird "CURRENT_SCHEMA" behavior

From: Maxim Demenko <>
Date: Wed, 04 Nov 2009 19:07:29 +0100
Message-ID: <>

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 Received on Wed Nov 04 2009 - 12:07:29 CST

Original text of this message