Skip to Main Content

Cloud Platform

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!

Error While Loading file from Oracle object storage

user10801042Sep 13 2020 — edited Sep 13 2020

I created a bucket from Admin user console and uploaded an file to oracle object storage.

Using the file URL, i am trying to load file to autonomous database table, using copy_data procedure but it gives me bellow error :

ORA-20401: Authorization failed for URI - https://objectstorage.us-ashburn-1.oraclecloud.com/n/XXXXX/b/First_Bucket/o/test.csv

ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 979

ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 2240

ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 2263

ORA-06512: at line 2

While, If I use pre-authenticate option for file on admin console, which provides an different URL. My load process works perfectly fine.

Comments

Post Details

Added on Sep 13 2020
0 comments
150 views