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).