Forum Stats

  • 3,783,605 Users
  • 2,254,809 Discussions
  • 7,880,480 Comments

Discussions

Error While Loading file from Oracle object storage

user10801042
user10801042 Member Posts: 1
edited Sep 13, 2020 4:16PM in General Questions

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.