Error when calling dbms_cloud.export_data

Question

I'm trying to do my first CSV export into an existing AWS S3 bucket. Calling with type CSV:

call dbms_cloud.export_data(credential_name => 'cred', file_uri_list => 'https://s3.us-east-2.amazonaws.com/bucket/test/object.csv',
format => json_object('type' value 'csv', 'compression' value 'gzip'), query => 'select * from table');

Produces this error:


ERROR at line 1:
ORA-20000: Export operation is only allowed for Oracle Datapump
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1181
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 3943
ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 3962
ORA-06512: at line 1

I'm able to get it to work with type: JSON and with compression disabled. Any idea why CSV doesn't work?

prashant G · Accepted Answer · 2025-11-18 16:13:54Z

0

cloud export data is only determined by its new value credentials

this is the json_object

this is basically how gmail works

i did know this long ago, but i dont know if i really like gmail that much

export dump pumps line 1 and calls dbs_cloud

edited Nov 18 at 16:13

answered Nov 18 at 16:13

prashant G

11 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Community Nov 18 at 16:27

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Error when calling dbms_cloud.export_data

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related