Oracle PL/SQL Tutorial/SQL PLUS Session Environment/current schema
alter session set current_schema=scott
SQL>
SQL>
SQL>
SQL> alter session set current_schema=scott;
ERROR:
ORA-01435: user does not exist
SQL> show user
USER is "sqle"
SQL>
SQL>
SQL>
SQL>
SQL> alter session set current_schema=scott;
ERROR:
ORA-01435: user does not exist
SQL> show user
USER is "sqle"
SQL>