Alter Session Set Current_Schema
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.
KeywordsDatabase Object Database Link Statement Parsing Prior Release Foreign Schema
Unable to display preview. Download preview PDF.