Forum Stats

  • 3,783,605 Users
  • 2,254,809 Discussions


Error While Loading file from Oracle object storage

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 -

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.