Oracle Multitenant Database Workshop («ODBMT»)

Oracle Multitenant is an option for the Oracle database in which the database is divided into so-called containers and thus a physical separation of the metadata of the database (CDB$ROOT) from the metadata and data of the applications (pluggable databases, or PDBs for short) takes place.

The topics range from the architecture of the container database and pluggable databases to local and common objects, creation and administration of PDBs and application containers.

It is a course that requires prior knowledge of data administration. The workshop offers sufficient space for exercises in which the newly acquired knowledge can be implemented or existing knowledge can be deepened.

Topics:

• Architecture of the Oracle multitenant database
• Security and schema concept of the multitenant database
• The advantages and disadvantages of the multitenant database architecture
• Administration - differences to non-CDB databases
• PDB management (creating and cloning PDBs)
• Migration of non-CDB databases to Multitenant
• Application Container
• Backup and recovery
• Administration - other topics
• Upgrade in Multitenant Environments