Use Case for Preparing the Target Database for Migration

Following is a sample use case for preparing a target database for migration.

1. Create an Autonomous Database. If the target autonomous database is already present you can skip this step.

2. Check the GLOBAL_NAMES parameter. If it's set to true, change it to false.

   sqlplus > show parameter global
   NAME                                 TYPE    VALUE
   ------------------------------------ ------- ------------------------------
   global_names                         boolean TRUE
   
   sqlplus > alter system set global_names=false

3. Create a database administrator user that has full Oracle Data Pump privileges for initial load to be performed. A user that has the DATAPUMP_IMP_FULL_DATABASE role is required for the export operation at the target database. This user is selected as database administrator when you create Database connections with the target databases.

   See Oracle Data Pump in the Oracle Database Utilities guide for more information.