Alter Session Set Current_Schema

  • Norbert Debes


ALTER SESSION SET CURRENT_SCHEMA was undocumented in Oracle8 and prior releases. It is partially documented in the Oracle8i, Oracle9i, and Oracle10g SQL Reference manuals. There are undocumented restrictions concerning certain database objects. Restrictions apply to Advanced Queuing, the SQL statement RENAME, and database links. The CURRENT_SCHEMA session parameter offers a convenient way to perform operations on objects in a schema other than that of the current user without having to qualify the objects with the schema name. It does not affect the privileges of a session.


Database Object Database Link Statement Parsing Prior Release Foreign Schema 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Norbert Debes 2009

Authors and Affiliations

  • Norbert Debes

There are no affiliations available

Personalised recommendations