My Oracle Support Banner

How to Use Data Pump on Agile Product Lifecycle Management (PLM) Databases for Database Export or Import (Doc ID 1437445.1)

Last updated on OCTOBER 14, 2024

Applies to:

Oracle Agile PLM Framework - Version 9.2.0.0 and later
Information in this document applies to any platform.
Data Pump is the preferred method for moving data between databases. It outperforms the original export and import on average of 10 to 1 and provides additional functionality not available on the original export/import utilities. This document discusses an alternate method for using Data Pump on all versions of Agile PLM deployed on Oracle 10g database and above. Exporting and Importing databases using Data Pump also allows for easy cloning of Agile Database Instances. In earlier versions of Agile, the export and import were done using the agile9exp and agile9imp commands.




Purpose

The purpose of this document is to familiarize the reader with the use of Data Pump and to standardize the process of using this utility for activities relating to moving data on installations using Oracle database 10g and above. 

Note: The original Export/Import utilities (exp/imp) utilities have been desupported as of 11g, which was release in September 2007. Please refer to this document for more details: https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-original-export-utility.html#GUID-901CBBE0-65FB-439E-942D-F2038C18BCD2 
Note:  In the examples below and/or the attached document, user details (including login/password) / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner. 
Note: Please refer to the attached Word document called UsingDataPumpOnAgilePLMDatabases.doc for more details.

Scope

1. How does one get and install Data Pump?

Data Pump is included with Oracle database 10g and above. It is a set of PL/SQL packages that provide the Application Program Interface (API) to the command line utility.

2. What is needed in the way of permissions for using Data Pump?

If the Agile PLM version is 9.2, use the following steps to grant these permissions:

1. Log on to the database server as the user that owns the Oracle installation.

2. Using SQL*Plus connect as SYSDBA and issue the following commands:

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
 1. How does one get and install Data Pump?
 2. What is needed in the way of permissions for using Data Pump?
 3. How is Data Pump implemented?
 4. Where are these files located?
 5. How is Data Pump invoked for exports?
 6. How is Data Pump invoked for imports? 
 7. What is the alternate method for importing?
 8. How does one invoke the alternate method for importing?
 9. What is attached to this note?
 10. How does one provide the dump file to Oracle Support?
Details
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.