Table of Contents Previous Next


7 Migration Toolkit Command Options : 7.6 Oracle Specific Options

-objecttypes schema_name
Import all users and roles from the source database. Please note that the ‑allusers option is only supported when migrating from an Oracle database to an Advanced Server database.
-users user_list
Import the selected users or roles from the source Oracle database. user_list is a comma-separated list of user/role names (e.g. -users MTK, SAMPLE, acctg). Please note that the -users option is only supported when migrating from an Oracle database to an Advanced Server database.
All other profile parameters such as the Oracle resource parameters are not imported. The Oracle database user specified by SRC_DB_USER must have SELECT privilege on the Oracle data dictionary view DBA_PROFILES.
Please note that the ‑allProfiles option is only supported when migrating from an Oracle database to an Advanced Server database.
-profiles profile_list
Import the selected, custom (that is, user-created) profiles from the source Oracle database. profile_list is a comma-separated list (with no intervening space characters) of profile names (e.g. -profiles ADMIN_PROFILE,USER_PROFILE). Oracle non-custom profiles such as DEFAULT and MONITORING_PROFILE are not imported.
As with the -allProfiles option, only the password parameters are imported. The Oracle database user specified by SRC_DB_USER must have SELECT privilege on the Oracle data dictionary view DBA_PROFILES.
Please note that the -profiles option is only supported when migrating from an Oracle database to an Advanced Server database.
Include the -importPartitionAsTable parameter to import the contents of a partitioned table that resides on an Oracle host into a single non-partitioned table. table_list is a comma-separated list of table names (e.g. -importPartitionAsTable emp, dept, acctg).
The dblink_ora module provides Advanced Server-to-Oracle connectivity at the SQL level. dblink_ora is bundled and installed as part of the Advanced Server database installation. dblink_ora utilizes the COPY API method to transfer data between databases. This method is considerably faster than the JDBC COPY method.
The following example uses the dblink_ora COPY API to migrate all tables from the HR schema:
The target Advanced Server database must have dblink_ora installed and configured. For information about dblink_ora, please see the Database Compatibility for Oracle Developer's Guide, available at:
To migrate all database links using edb as the dummy password for the connected user:
You can alternatively specify the password for each of the database links through a comma-separated list of name=value pairs. Specify the link name on the left side of the pair and the password value on the right side.
-allSynonyms
Include the -allSynonyms option to migrate all public and private synonyms from an Oracle database to an Advanced Server database. If a synonym with the same name already exists in the target database, the existing synonym will be replaced with the migrated version.
-allPublicSynonyms
Include the -allPublicSynonyms option to migrate all public synonyms from an Oracle database to an Advanced Server database. If a synonym with the same name already exists in the target database, the existing synonym will be replaced with the migrated version.
-allPrivateSynonyms
Include the -allPrivateSynonyms option to migrate all private synonyms from an Oracle database to an Advanced Server database. If a synonym with the same name already exists in the target database, the existing synonym will be replaced with the migrated version.
-useOraCase
Include the -useOraCase option to preserve the Oracle default, uppercase naming convention for all database objects except for procedural objects (that is, functions, procedures, and packages) when migrating from an Oracle database to an Advanced Server database.
The default behavior of the Migration Toolkit (without using the -useOraCase option) is that database object names are extracted from Oracle without enclosing quotation marks (unless the database object was explicitly created in Oracle with enclosing quotation marks). The following is a sample portion of a table DDL generated by the Migration Toolkit with the -offlineMigration option:
For such desired application usage, perform the migration with the -useOraCase option. The DDL then contains all database object names (except for functions, procedures, and packages unless created in Oracle with quoted names) enclosed in quotes:

7 Migration Toolkit Command Options : 7.6 Oracle Specific Options

Table of Contents Previous Next