Upload file from OCI Object Storage to Oracle ATP

[@manishgarodia021]

Excellent video with great detail. Following the steps in the video, I tried to load data from oci object storage to adb. Worked well for me. Thanks much.

[@TechSupper]

Glad it helped

[@AarifAhmad2204]

Hi Ankur, Really helpful approach. Can you please let me know- what will values in format parameter's If I'll upload data using .xlsx file? I am having issue while processing the xlsx file using dbms_cloud due to using csv parameter, and not sure for excel file parameter. Can you please help me on this?

[@TechSupper]

I didn't get your question Aarif

[@AarifAhmad2204]

@@TechSupper My question is- You upload data into the table using csv file. I am trying to do the same using the excel file. But unable to upload data into the ATP db when I try the excel file

[@TechSupper]

What's the error you are getting ?

[@vandanapatel5884]

How can we import object storage file data in Other schema table (other than SYS schema table)?

[@TechSupper]

What's the issue.. This is same as shown in the video

[@user-kz2pq8pl5v]

How can we upload a file coming as base64 string in rest API to Oracle BLOB column using OIC Oracle Connector.

[@TechSupper]

you can convert the base64 to file reference and map the filereference to column