Export dumps directly on Object store.
A reader, January 13, 2021 - 6:17 am UTC
We are still looking for the feature that will export dump files directly to the Object store using DBMS_DATAPUMP api. Could you please let me know if you have any update on this.
A reader, January 19, 2021 - 1:45 pm UTC
Thanks for the reply!
Actually I tried the example that will export dump file directly to the Object store but getting below error and not sure why am I getting this even after correct URI for bucket and Credential.
Error:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file
"https://swiftobjectstorage.ap-hyderabad-1.oraclecloud.com/v1/axqj0jxv2wlw/LetHaveBucket/o/exp_datapump_api01.DMP"
ORA-17503: ksfdopn:11 Failed to open file
https://swiftobjectstorage.ap-hyderabad-1.oraclecloud.com/v1/axqj0jxv2wlw/LetHaveBucket/o/exp_datapump_api01.DMP
ORA-17500: ODM err:ODM Credential Not Found
ORA-17503: ksfdopn:11 Failed to open file
https://swiftobjectstorage.ap-hyderabad-1.oraclecloud.com/v1/axqj0jxv2wlw/LetHaveBucket/o/exp_datapump_api01.DMP
ORA-17500: ODM err:ODM Credential Not Found
Actually we are working on FA SaaS application that uses ATP database 19c(19.5). Could you please confirm which DB version supports feature of exporting dumps directly to the object store using DBMS_DATAPUMP api.
January 25, 2021 - 2:49 pm UTC
Sorry I'm not sure what the issue is here; try following up with support.