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