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: 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!