My Oracle Support Banner

How To Validate Inputs Needed For ADW/ATP Data Pump Import (Doc ID 2493452.1)

Last updated on JANUARY 17, 2019

Applies to:

Autonomous Transaction Processing - Version NA to NA [Release NA]
Autonomous Data Warehouse Cloud - Version N/A to N/A
Information in this document applies to any platform.

Goal

Oracle Data Pump offers very fast bulk data and metadata movement between Oracle databases and Autonomous Data Warehouse.
The Data Pump Import has the following steps:

Upload files to Object storage.
Store your Object Storage credential.
Run Data Pump Import.

The steps for Data Pump Import is documented here.
This document explains steps to validate the inputs required to run the command.

Solution

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
Goal
Solution
 1. What is the format for OCI Object Storage URI
 2. How to find the inputs for OCI Object Storage URI mentioned in the above step
 3. What is the command for different impdp client versions
 4. How to create a credential
 5. How to enable credential, if it's disabled
 6. How to find all the credentials created 
 7. Is it necessary to have default credentials set for Data Pump Import operation
 8. How to find the default credentials set(needed for 12.2 clients and lower version of impdp)
 9. How to validate the credentials and object storage URI is correct
 10. How to validate the auth token saved for the credential name
 11. How to list all files in DATA_PUMP_DIR location
 12. How to move files from DATA_PUMP_DIR to Oracle OCI Object Storage
 14. How to view ddl contents of an export dump file generated using expdp
 15. How to validate the size of  Data Pump Import file
References

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