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:
\install\database.
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
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