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?
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.
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.
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.
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.
alter session set current_schema = otheruser;
should do the trick.
Just right clic on the created connection and select "Schema browser", then use the filter to display the desired one.
Cheers.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With