Database Error Messages

ORA-28451

incomplete ALTER DATABASE LINK statement

Cause

An attempt was made to reset the password for an invalid shared database link without providing either the CONNECT TO clause, the AUTHENTICATED BY schema_name clause or the IDENTIFIED BY password clause.


Action

In the ALTER SHARED DATABASE LINK statement, ensure to provide all these clauses -

  • CONNECT TO
  • AUTHENTICATED BY schema_name
  • IDENTIFIED BY password