Data pump import to ATP failing with ORA-17500: ODM err:ODM HTTP Unauthorized
Hello,
I'm trying to import data from on premise database 12.2.0.1 to ATP database 18 Free tier
expdp and impdp are version 12.2.0.1
export file named DEMOSOT12.DMP is uploaded to Oracle Cloud infrastructure Object Storage
Firstly I created Auth Token
Then I created credential:
begin
DBMS_CLOUD.CREATE_CREDENTIAL(
credential_name=> 'DEF_CRED_NAME',
username => '<my_username>',
password => '<MY_TOKEN>'
);
end;
/
dbms_cloud.enable_credential(credential_name => 'DEF_CRED_NAME');
alter database property set default_credential='ADMIN.DEF_CRED_NAME';
and then I tried import using native URI format
impdp admin/pass@database directory=data_pump_dir dumpfile=DEF_CRED_NAME: