A scheme is a synonym for a user in oracle - you do not specify a scheme in the connection string - you specify a username . Each user may or may not be the owner of database objects (tables, views, procedures, etc.). To access the owner of the objects by another user (scheme), you can:
- Use full name:
SCHEMA.OBJECTNAME - Create a private synonym that pseudonizes the object:
CREATE SYNONYM mytable
FOR otherschema.sometable - Create a public synonym that all users can use to access the object:
CREATE PUBLIC SYNONYM sometable FOR otherschema.mytable