How do I change the default schema in sql developer?
Solution 1:
alter session set current_schema = otheruser;
should do the trick.
Solution 2:
Just right clic on the created connection and select "Schema browser", then use the filter to display the desired one.
Cheers.
Solution 3:
I don't know of any way doing this in SQL Developer. You can see all the other schemas and their objects (if you have the correct privileges) when looking in "Other Users" -> "< Schemaname >".
In your case, either use the method described above or create a new connection for the schema in which you want to work or create synonyms for all the tables you wish to access.
If you would work in SQL*Plus, issuing ALTER SESSION SET CURRENT_SCHEMA=MY_NAME
would set your current schema (This is probably what your DBA means).