Exporting the Oracle Source Database Using Data Pump
This procedure describes how to use the Oracle Data Pump utility to export the Windchill schema of the source system so that it can be imported into the target system. The procedure assumes that you are familiar with the Oracle Data Pump tool and have access to its documentation. PTC recommends that the source schema user name be used as the target schema user name. On both the source and target database, the <database_directory> should be created and “Read, Write” privileges to it should be granted to the user System. See the Oracle documentation for more details.
1. Export the source schema using Data Pump commands. For example:
expdp system/<Password>@<sid> SCHEMAS=<source_dbusername>
DIRECTORY=<database_directory> DUMPFILE=<db_dump_file>
logfile=<db_exp.log> EXCLUDE=STATISTICS
Execute the following command to export the indexes if you are planning to use Oracle 19C R2 database for upgrade:
expdp system/<Password>@<sid> SCHEMAS=<source_dbusername> include=index
DIRECTORY=<database_directory> DUMPFILE=<index_dump_file.dmp> logfile=<db_exp.log>
See the Oracle documentation for more details about the expdp utility.
2. The user cannot already exist on the target database. If it does, take a backup of the target user schema and then take the appropriate steps to drop the user schema and all of its data. Otherwise, when importing the database on the target system, follow the instructions for Using Data Pump to Import to a Different Target Schema Username.
3. Copy the source_db_dump_file to the target system.