Changing the Current Schema

Often it is  time consuming process for someone to put the schema name in front of the objects from that schema while processing the objects of the schema. DBA ‘s usually work with system or sys users and they have to do this alias process for not to face with ORA-00942 error (table or view does not exist). But if the connected user doesn’t have permission on the current schema object you will still get ORA-00942.

To avoid the same one case you the below command (also can be used in SQL Developer/Toad)

alter session set current_schema=SCHEMA_NAME ; /*without quotes*/

Example : 

ALTER SESSION SET CURRENT_SCHEMA = APPS;