There will be scheduled password change happens every month for particular schema and we have some pvt db links created on that schema. We want to re-create the db links again whenever password get changed. Oracle version is 11g.
Is there any available to recreate existing the pvt db link without knowing the password ( new password ) of the schema where the password reset happens frequently.