Running the Data Pump Utility Using the Wizard

To run the data pump utility using the wizard, complete the following steps:

Note: Skip the first two steps if you are using a Microsoft SQL Server Database.

  1. From the command line, execute: sqlplus sys/password@<db_tns_names_entry> as sysdba
  2. Go to p6suite\database\scripts\install\PM_<release_level>, and execute manual_script_before_install.sql.
  3. Go to the <P6_EPPM_Home>\database folder.
  4. Run migrate.bat (with Windows) or migrate.sh (with UNIX or Linux).
  5. Follow the prompts on each screen to provide connection information for the source database and the target database.

    Note: When using an Oracle schema, the migration utility allows you to create new tables or use existing tables in the target instance, but new schema users must be created through the migration process. The ability to map to existing schema users is not currently available through the migration process.

Related Topics

Using the Migrate Database Wizard

Running a Schema Validation on the Database

Running the Data Pump Utility From the Command Line



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, September 30, 2016