Preparing the target database for migration
Before you can migrate data with Oracle Cloud Infrastructure Database Migration, manually configure your target database as described here.
-
To configure an Autonomous database as a target for migration, run the following SQL commands:
-- Global Names ALTER SYSTEM SET GLOBAL_NAMES=FALSE; -
To configure a non-Autonomous, single-tenant (non-CDB) or a specific pluggable database (PDB) within a multi-tenant (CDB) as a target for migration, run the following SQL commands:
-- Global Names ALTER SYSTEM SET GLOBAL_NAMES=FALSE; -
To configure a non-Autonomous, multi-tenant (CDB) as a target for migration, run the following SQL commands:
-- Connect to CDB and run: -- Global Names ALTER SYSTEM SET GLOBAL_NAMES=FALSE; -
Use case
Following is a sample use case for preparing a target database for migration.