Tag: Multitenant

How to Plug In an Unplugged PDB into a Different File Location

Introduction Oracle Multitenant allows you to copy and move Pluggable Databases (PDBs) across Container Databases (CDBs) in various ways, including PDB (Refreshable) Clones, PDB Relocate, and PDB Unplug and Plug. Unplug and Plug might be preferred if you are dealing with very large databases, as copying the data files over scp may be faster than…

Migrating from non-encrypted, non-CDB on local file system to encrypted PDB on ASM

Introduction Oracle Databases on Oracle Cloud are created using the Multitenant architecture. All databases are encrypted using Transparent Data Encryption (TDE) by default. All databases on Exadata, Bare Metal machines, and RAC on Virtual Machines use ASM storage management. For Single Instance databases on Virtual Machine DB systems you have the choice between Logical Volume…

How to create PDBs with different Character Sets in the same CDB

Introduction Oracle Multitenant enables you to migrate and consolidate multiple databases as PDBs into one CDB. Starting with Oracle Database release 12.2.0.1, PDBs within the same CDB can be of different character sets, provided the CDB is created with the AL32UTF8 character set. If you are using Application Containers, then all application PDBs under the…