What is the REMOTE_DEPENDENCIES_MODE parameter?

What is the REMOTE_DEPENDENCIES_MODE parameter?

Rating:

The REMOTE_DEPENDENCIES_MODE parameter is used to specify the remote dependency mode that Oracle server uses to manage remote dependencies among objects. The REMOTE_DEPENDENCIES_MODE parameter can be set to either TIMESTAMP or SIGNATURE. Setting the REMOTE_DEPENDENCIES_MODE parameter to TIMESTAMP indicates that Oracle server uses the timestamp mode for managing remote dependencies. Setting the REMOTE_DEPENDENCIES_MODE parameter to SIGNATURE indicates that Oracle server uses the signature mode for managing remote dependencies.

The REMOTE_DEPENDENCIES_MODE parameter is specified in the init.ora file (initialization parameter file).

Syntax:

REMOTE_DEPENDENCIES_MODE = TIMESTAMP | SIGNATURE

The remote dependency mode can be dynamically altered by using the DDL statements. For example, the ALTER SYSTEM statement alters the dependency mode at the system level.

Syntax:

ALTER SYSTEM SET REMOTE_DEPENDENCIES_MODE = TIMESTAMP | SIGNATURE;

The ALTER SESSION statement alters the dependency mode for the current session.

Syntax:

ALTER SESSION SET REMOTE_DEPENDENCIES_MODE = TIMESTAMP | SIGNATURE;

If the REMOTE_DEPENDENCIES_MODE parameter is not specified either in the init.ora file or by using the ALTER SYSTEM or ALTER SESSION statement, TIMESTAMP is the default value. It means that unless the REMOTE_DEPENDENCIES_MODE parameter is explicitly specified a value, Oracle server uses the timestamp mode to manage remote dependencies.

Rating: