Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Cloud - Import Export - Error Unable to open dump file

SuriJan 26 2021

Hi, I've created Oracle Cloud Account and created database. Now I'm trying to Import SH schema data using import export from Cloud Powershell. I'm getting below error while importing data.

impdp admin@demodb_high \
directory=data_pump_dir \
credential=def_cred_name \
dumpfile=https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/idjgu0yt3kru/bucket-20210125-2246/EXP_SH_TABLE.DMP \
encryption_pwd_prompt=yes \
transform=segment_attributes:n \
transform=dwcs_cvt_iots:y transform=constraint_use_default_index:y \
exclude=cluster,indextype,db_link

Error Details :
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/idjgu0yt3kru/bucket-20210125-2246/EXP_SH_TABLE.DMP" for read
ORA-17503: ksfdopn:11 Failed to open file https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/idjgu0yt3kru/bucket-20210125-2246/EXP_SH_TABLE.DMP
ORA-17500: ODM err:ODM HTTP Unauthorized
Can someone help me what I'm missing here
Note: I have created Public Key and also uploaded to OCI console.

Comments

Post Details

Added on Jan 26 2021
2 comments
528 views