Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-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