ALTER DATABASE LINK

Use the ALTERDATABASELINK statement to modify a fixed-user database link when the password of the connection or authentication user changes.

Notes:

You cannot use this statement to change the connection or authentication user associated with the database link. To change user, you must re-create the database link.

You cannot use this statement to change the password of a connection or authentication user. You must use the ALTER USER statement for this purpose, and then alter the database link with the ALTERDATABASELINK statement.

This statement is valid only for fixed-user database links, not for connected-user or current user database links. See CREATE DATABASE LINK for more information on these two types of database links.

Prerequisites

To alter a private database link, you must have the ALTERDATABASELINK system privilege. To alter a public database link, you must have the ALTERPUBLICDATABASELINK system privilege.

The ALTERDATABASELINK statement is intended only to update fixed-user database links with the current passwords of connection and authentication users. Therefore, any clauses valid in a CREATEDATABASELINK statement that do not appear in the syntax diagram above are not valid in an ALTERDATABASELINK statement. The semantics of all of the clauses permitted in this statement are the same as the semantics for those clauses in CREATEDATABASELINK. Refer to CREATE DATABASE LINK for this information.

Examples

The following statements show the valid variations of the ALTERDATABASELINK statement: