Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I change the default schema in sql developer?

I don't see any tables in the tables section of a database that I've linked to w/ SQL developer. The DB admin says I need to change the default schema in SQL developer. How do I do that?

enter image description here

like image 280
bernie2436 Avatar asked Jul 01 '13 15:07

bernie2436


People also ask

How do I change the default database schema?

In the Database Administration view upper pane, select the database. Right-click the database and select Set default schema. The Set default schema dialog appears. Select the schema that you want to make the new default schema for the database from the drop-down list and click Ok to save the changes.

What is the default schema name in Oracle?

The name of the default schema used by Oracle Database Exadata Express Cloud Service is called the Host Schema and can be found from the Oracle Application Express About option.

How do I change the default directory in SQL Developer?

You can as well create a folder anywhere you want to use as your default, create a sql developer shortcut on desktop and right click on it> choose properties and under the target field, paste the path of the folder which you want to use as your default for saving sql files.

How do I change a schema in SQL?

To change the schema of a table by using SQL Server Management Studio, in Object Explorer, right-click on the table and then click Design. Press F4 to open the Properties window. In the Schema box, select a new schema. ALTER SCHEMA uses a schema level lock.


Video Answer


2 Answers

alter session set current_schema = otheruser;  

should do the trick.

like image 50
Ram Avatar answered Sep 22 '22 09:09

Ram


Just right clic on the created connection and select "Schema browser", then use the filter to display the desired one.

Cheers.

like image 20
Carlos Negron Avatar answered Sep 21 '22 09:09

Carlos Negron