You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

dbms_cloud.copy_data gives ORA-20404: Object not found

edited Apr 16, 2022 7:54AM in Autonomous Database 1 comment

Summary

Following "Oracle by Example" tutorial yields above error.

Content

On this page:

https://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/atp/obe_loading_your_data_into_autonomous_transaction_processing/loading_your-data_into_autonomous_transaction_processing.html

step 4 Copy data from object store to ... database ...

yields the following error:

ORA-20404: Object not found - https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/xxxxxxxx/tutorial_load_atpc/cust1v3.dat

(I redacted my tenant name, here and in the code snippet below.)

My console confirms that all 10 files (including the one for which I have shown the error) are stored as objects in the tutorial_load_atpc bucket. All 10 copy_data operations failed with the same error. And, everything prior to step 4 worked perfectly (as best I can tell).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!