My Oracle Support Banner

How To Load Data To ADW/ATP Using DBMS_CLOUD.COPY_DATA Method And Find/Validate The Inputs Required (Doc ID 2493502.1)

Last updated on NOVEMBER 19, 2019

Applies to:

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

Goal

 This document explains how to load data to ADW/ATP using the copy data and validate/find the inputs required to run the copy data successfully

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
 Steps to load data using copy data method
  1. Create Credentials
  2. Create table for data load
  3. Load data
 How to Validate/find the required inputs
 1. How to generate the Auth token required for create credential
 2. How to validate the table is created in the database
 3. What is the format for OCI object storage URL
 4. How to find the inputs for OCI Object Storage URI mentioned above. 
 5. How to enable credential, if it's disabled
 6. How to find all the credentials created
 7. How to validate whether the credentials and object storage URI is correct
 8. How to find the status of the operation
 9. How to find the logs of the load
References

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