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

Last updated on APRIL 13, 2020

Applies to:

Autonomous Transaction Processing - Version NA to NA [Release NA]
Autonomous Database Serverless - 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

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

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