19 September 2019

Import in Autonomous Transaction Processing Database

In this article, I would like to show the easy steps to import a Oracle datapump exportfile into an (existing) ATP database. Note, you are always responsible yourself to check the documentation and make your own decisions. We all know that documentation can be confusing, showing too many details and referring you back and forth to other locations. I hope these simple steps will provice some help.


Create a credential

Connect with SQL*Developer to the ATP database, and run (set parameters how you like)

BEGIN
  DBMS_CLOUD.CREATE_CREDENTIAL(
    credential_name => 'MY_CRED_NAME',
    username => 'john.doe@mycompany.com',
    password => 'password'
  );
END;
/


Upload the datapump file to a bucket

Go to Object Storage>Object Storage.














Create a bucket for holding the dumpfile.

Once the bucket is created, upload your dumpfile into the bucket.

In the menu to the right (three dots) on this dumpfile, you can Create a Pre-authenticated request.

This will give you a “Pre-Authenticated Request URL” that you need to copy/save.


Run the import

Now with a local Oracle Client (I used Oracle 18c client on windows 10), you can import.

The client_home needs the files from the wallet-zip (unzipped) in network/admin folder.

You can now check connectivity with the Oracle Client:

sqlplus admin/<admin_pw>@db01_high

The import can be run as:

impdp admin/<admin_pw>@db01_high directory=data_pump_dir credential=my_cred_name dumpfile=<pre-authenticated_request URL>


You may add extra impdp parameters as you wish.

No comments:

Post a Comment