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?

Northstar · Accepted Answer · 2025-11-18 16:08:50Z

1

DBMS_CLOUD.EXPORT_DATA cannot export CSV.
Even though the documentation isn't super obvious, Oracle ATP/ADW only supports:

type => 'datapump' (the only format allowed for export)
type => 'json' (for copying data out, not full export)

When you specify:

type => 'csv'

Oracle treats it as a non-Datapump export, and raises:

ORA-20000: Export operation is only allowed for Oracle Datapump

That’s why JSON works (because JSON export is implemented), but CSV doesn’t.

CSV is only supported by DBMS_CLOUD.COPY_DATA, not EXPORT_DATA

If you want CSV output, you must use:

call dbms_cloud.copy_data( credential_name => 'cred', file_uri_list => 'https://s3.../object.csv', format => json_object('type' value 'csv'), query => 'select * from table' );

edited yesterday

answered yesterday

Northstar

3744 silver badges16 bronze badges

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

1 Comment

Fastnlight yesterday

AI generated content is banned on Stack Overflow. Please read the AI Policy for more information.

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 yesterday

answered yesterday

prashant G

11 bronze badge

New contributor

1 Comment

Community yesterday

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

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related