Once an Oracle session has been established, the Database Navigator will be used to navigate around schema objects.
For Oracle, the Database Navigator can hold one or more Schemas, all of which can be browsed, searched and modified.
Below is an example screenshot of an Oracle session and a Database Navigator with several schemas:
Multiple Oracle schemas |
As you can see in this screenshot, this Database Navigator holds several schemas, including HR, OE, SCOTT, SYS and SYSTEM.
When opening the SQL Editor/Script Editor, the default session schema is the same as the logged in user. Any Object Editor that will be opened will have the same schema selected by default as well.
Note: cross-schema foreign key constraints will only show up if you also have the parent schema available in the list (see connection profile options).
|
