Prerequisites:

• SOURCEDBA source database which has a schema that owns a private database link
• TARGETDB1, the original target database for the link
• TARGETDB2, a clone of TARGET1 that was renamed to "TARGETDB2"

Why?

I have an application that I support that uses a pair of databases, one holds detail info and one holds summary info. Read more about Pointing a private database link at another database without knowing the password...sorta...