Pluggable Databases Node

This section covers the following topics:

About Pluggable Databases

The Pluggable Databases node is visible when a user with the SYSDBA privilege connects to a multitenant container database (CDB). When expanded, a set of child Pluggable Database Nodes are visible, one for each available pluggable database (PDB) in the CDB.

For more information about multitenant architecture features in ODT, see About Multitenant Container Databases.

Note:

This is a feature of Oracle Database 12.1 or later.

How the Pluggable Databases Node Works

To perform actions on this 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.

Menu Options

Menu Option Description

New Pluggable Database

Create a new Pluggable Database using the New Pluggable Database Dialog.

Plug

Plugs in a Pluggable Database using the Plug Pluggable Database Dialog.

Query Window

Opens the Query Window so that you can execute SQL and PL/SQL queries from Visual Studio.

Filter

Opens the Filters Tab on the Connection Dialog to control which child nodes appear under the collection.

Refresh

Refreshes the node.

Properties

Shows properties for the node.