This tutorial covers how to use Multitenant Container Databases in Visual Studio.
The Oracle Multitenant option is introduced in Oracle Database 12c Release 1 to enable an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to any Oracle client application as a non-CDB. Note that all Oracle database versions prior to Oracle Database 12c Release 1 (12.1) are known as non-CDBs.
PDBs can be created quickly from a seed pluggable database or cloned from another pluggable database. These operations are much faster than creating a non-CDB database from scratch. Pluggable databases can also be unplugged, resulting in a set of database files and an XML metadata file that can be plugged into other container databases.
For developers, this feature makes testing a database configuration with your application as simple as cloning an existing PDB, or plugging in a PDB in the form of some provided database files. Similarly, a pluggable database can be shared with other developers, either by cloning or through unplugging and sharing the database files. At deployment time, a development PDB can simply be unplugged from the development container database and plugged into the production container database.
This content is intended for the following job role(s): Application Developer
Release Date: 19-SEP-2013