Running the Data Pump Utility From the Command Line

Note: Do not use the data pump utility to convert the database type from EPPM to PPM or from PPM to EPPM.

To run the data pump utility from the command line, complete the following steps:

  1. Open a new command line console.
  2. Go to \install\database.
  3. Run the command with the following parameters to define the migration:

    With Windows

    migrate.bat -source sa/sa@sqlserver:rcgsrv:1433:vader_pmdb -target system/manager@oracle:rcgsrv:1521:rcg02 -db PM

    With Windows (Creating Non-Default Oracle Users)

    migrate.bat -source sa/sa@sqlserver:rcgsrv:1433:vader_pmdb -target system/manager@oracle:rcgsrv:1521:rcg02 -db PM -admuser admjeff -privuser privjeff -pubuser pubjeff

    With UNIX or Linux

    sh migrate.sh -source sa/sa@sqlserver:saumverm-lap\primavera:1433:PMDB -dattbsp <Name of data tblspc at target> -ndxtbsp <Name of index tblspc at target> -pxtbsp <Name of px tblspc at target> -lobtbsp <Name of LOB tblspc at target> -admuser <admuser at target> -admpass <admuser password at target> -privuser <privuser at target> -privpass <privuser password at target> -pubuser <pubuser at target> -pubpass <pubuser password at target> -pxrptuser <pxrptuser at target> -pxrptpass <pxrptuser password at target> -bgjobuser <bgjobuser at target> -bgjobpass <bgjobuser password at target> -target system/admin@oracle:oldb-orcl:1521:PMDB

    For example:

    sh migrate.sh -source sa/sa@sqlserver:saumverm-lap\primavera:1433:PMDB -dattbsp PMDB_DAT1 -ndxtbsp PMDB_NDX1 -pxtbsp PMDB_PX_DAT1 -lobtbsp PMDB_LOB1 -admuser admuser -admpass admuser -privuser privuser -privpass privuser -pubuser pubuser -pubpass pubuser -pxrptuser pxrptuser -pxrptpass pxrptuser -bgjobuser bgjobuser -bgjobpass bgjobuser -target system/admin@oracle:oldb-orcl:1521:PMDB

Related Topics

Using the Migrate Database Wizard

Running a Schema Validation on the Database

Running the Data Pump Utility Using the Wizard



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

Last Published Friday, September 30, 2016