Preparing Oracle Database migration users for migration
Prepare your database migration users using either of the following methods:
- Prepare your database migration users by running the database preparation script. (Recommended option).
- Manually configure your Oracle database migration users by following the documentation and running the SQL commands.
Preparing your database migration users using the database preparation script:
- Navigate to the Create connection screen for the latest script.
- Download the database preparation script which is an SQL script file.
- Run the script locally.
- Will require a password for
GGADMINuser. - Analyze your database migration user for any missing required privileges.
- Performs the required operations on your database migration users to prepare them for the migration.
The script will prepare GGADMIN as the migration user. This is the
only user accepted in the Assessment.
For scenarios earlier than Oracle Database 19c (19.23) with multitenant
architecture where an online migration is required, C##GGADMIN will
be prepared as well, the script needs to run on CDB$ROOT. These
scenarios are only supported in the create migration option under the Migration
menu.
Manually configuring your database and migration users for migration:
To prepare your source and target database manually using the SQL commands, see the following topics:
- Preparing the source database for migration
Before you can migrate data with Oracle Cloud Infrastructure Database Migration, manually configure your source database as described here. - 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.
Parent topic: Prepare