Hello ,
I work on an on prem product which interacts with Autonomous Database residing in OCI using wallet. I have a requirement to use Oracle Datapump using Database link. I will move the data from source ADB to target ADB using ODP. The way we have decided to do it is using database link.
To create the database link of source in target I have to transfer the cwallet.sso file of source in the target database. Currently I am doing this manually, uploading the cwallet.sso to object storage, creating a PAR url, and then using that to copy the wallet file in the target database in a directory. Supplying this directory and source credential during create database link, I am able to connect to source ADB.
I need to automate this manual process. Is there a way an on prem product can copy the wallet file directly to Autonomous Database.