Relocate a PDB
To relocate a PDB follow these steps:
- From the Targets menu, select Databases.
- Under View select Search List. From the View menu select Expand All.
- Look for the source PDB and right-click the name of the PDB that you want to relocate.
- From the Oracle Database menu, and select Relocate.
- On the Source and Destination: Relocate Pluggable Database page specify the SYSDBA
and host credentials for the source CDB. For Exadata Cloud RAC use the OPC user
for Normal Host credentials. In the Container Database Destination section,
select the destination CDB and specify a name, and a display name for the PDB.
If you want to use an existing database link for a PDB relocation, click on Select an existing database link option and select the database link to be used. If you do not select one, then the system will create a database link to connect to the source PDB or database.
Provide the target CDB TDE wallet password.
Select either of the following Relocation modes:- Maximum Availability ensures there is no need to update the Connect Descriptor soon after the PDB relocation. You may do it at a later time, if required.
- Normal Availability requires you to update the Connect Descriptor after the PDB relocation.
- Click Relocate.