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) as a target for migration, run the following SQL commands:

-- Global Names
ALTER SYSTEM SET GLOBAL_NAMES=FALSE;
 
-- User system for Datapump
ALTER USER SYSTEM IDENTIFIED BY system_pwd ACCOUNT UNLOCK;

• 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;
   
  -- User system for Datapump
  ALTER USER SYSTEM IDENTIFIED BY system_pwd ACCOUNT UNLOCK SCOPE=BOTH;