db links

Pointing a private database link at another database without knowing the password...sorta...

Pointing a private database link at another database without knowing the password...

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.

Subscribe to db links