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;