Skip to Main Content

LiveLabs & Workshops

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating an external table in autonomous data warehouse with cloud object storage bucket

Anthony HarperMay 17 2022

All,
I am having difficulty creating an external table with dbms_cloud and object storage in an autonomous data warehouse.
I have created the following:
storage bucket.
test files in the storage bucket.
dynamic group for accessing the bucket defined with rule to include all autonomous databases.
a policy to allow the dynamic group to access buckets.
a resource principle credential in the autonomous data warehouse and granted to the schema user that will create the external table.
When I try to create the table using dbms_cloud.create_external_table I get the following error:
ORA-06564: object DATA_PUMP_DIR does not exist
I logged into the database as admin and tried to create a directory object data_pump_dir pointed to the object storage bucket. This generated the following error:
ora-65040 operation not allowed from within a pluggable database
When I tried to used the Database Actions | Data Load | Manage Cloud to create a cloud storage link I get an error creating the link:
ORA-20404: Object not found - https://objectstorage.us-phoenix-1.oraclecloud.com/n/xxxxxx/b/adw_ext_data/o/
What am I missing to access the object storage from the autonomous data warehouse?
Regards,
Anthony Harper

Comments

Robeen

Where does Oracle store the LCRs?
XStream Guide (0 Bytes)If I have 5 CDC applications, each will have its own outbound servers. Why is this? What is the benefits?

1 - 1

Post Details

Added on May 17 2022
1 comment
734 views