Error while fetching data from an external table ( for a file from OCI object storage)
Content
Hello,
I followed the instructions from the below link
Scripts used
SET DEFINE OFF
BEGIN
dbms_cloud.create_credential (
'pramod_obj_store_cred',
‘user_email@gmail.com',
'r4u.tH{BT_t(JePKkI6X’); — token from the OCI object store user
END;
/
BEGIN
DBMS_CLOUD.CREATE_EXTERNAL_TABLE(
table_name =>'happiness_report_2019_ext',
credential_name =>'pramod_obj_store_cred',
file_uri_list =>'https://objectstorage.us-ashburn-1.oraclecloud.com/n/idub6u1mhbz5/b/data_for_ml_user/o/world-happiness-report-2019.csv',
format => json_object('type' value 'csv', 'skipheaders' value '1'),
Tagged:
0