Before You Begin
(1) The target self-built Oracle database version is 10g, 11g, 12c, 18c, or 19c, and the version is later than or the same as that of the source database.
Permission Requirements of Target Server
Migration Mode | Required Permissions |
Full | SELECT ANY DICTIONARY, COMMENT ANY TABLE, CREATE ANY TABLE, ALTER ANY TABLE, CREATE ANY SEQUENCE, CREATE ANY INDEX, SELECT ANY TABLE, INSERT ANY TABLE, DROP ANY TABLE, DROP ANY TRIGGER, DROP ANY SEQUENCE, DROP ANY INDEX, DELETE ANY TABLE |
Incremental | SELECT ANY DICTIONARY, DELETE ANY TABLE, SELECT ANY TABLE, INSERT ANY TABLE |
Auditing Repair | SELECT ANY DICTIONARY, SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE |
Configuration on Target Server
Data source type: Set this parameter to Oracle. The source database can be migrated to the Oracle databases within the specified version range.
Server IP: Specifies the IP address of the target database.
Port number: Specifies the port of the target database.
User name: Specifies a user name used to connect to the target database.
Password: Specifies the password of the user used to connect to the target database.
Service name: Specifies the service name of the Oracle database.
CDB service name: Specifies the service name of the Oracle CDB. If the Oracle database is 12C or later versions, this field is required to collect system information.
Migration username: Specifies the actual Oracle schema of the target database. It is usually the same as the username.