Schemas Node
This section covers the following topics:
About Schemas
The Schemas node lists every schema selected in the Filters Tab on the Connection Dialog.
A schema is a collection of database objects, including logical structures such as tables, views, sequences, procedures, synonyms, indexes, clusters, and database links. A schema has the same name as the user who controls it.
You cannot hide the Schemas node through the Data Connections Tools/Option Page of Oracle Developer Tools.
How the Schemas Node Works
The Schemas node is visible from the Server Explorer tree when you right-click the connection node and select Change View, then Schemas. Otherwise, you see the Users node.
To perform actions on the Schemas node: right-click the node and from the menu, choose the appropriate command. To view the node's properties, select the node and/or click Properties in the node's menu.
If this collection node is filtered, the icon changes to include a funnel symbol. For more information about filtering, see Filtering Collection Nodes.
Menu Options
| Menu Option | Description |
|---|---|
|
New User |
Launches the designer to create a new user. |
|
Query Window |
Opens the query window for the connection. |
|
Filters |
Opens the Filters Tab to control which child nodes appear under the collection. |
|
Privileges |
Opens the privileges dialog. |
|
Refresh |
Refreshes the schemas node. |
|
Properties |
Displays the properties window. |
See Also