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;
- Additional configurations
Before you can migrate data with Oracle Cloud Infrastructure Database Migration, perform additional configurations for your target database for online migration as described here. - Use case
Following is a sample use case for preparing a target database for migration.
Parent topic: Preparing Oracle Database migration users for migration