RESET_CONFIGURATION_PROPERTY

The RESET_CONFIGURATION_PROPERTY function can be used to reset a configuration property to its default value.

RESET_CONFIGURATION_PROPERTY Function

DBMS_DG.RESET_CONFIGURATION_PROPERTY (
     property_name         IN VARCHAR2,
     severity              OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;

Parameters

Parameter	Description
property_name	The name of the configuration property whose value is to be reset to its default value.
severity	The severity associated with the status returned by this function. Severity will be one of the following Oracle error numbers: ORA-0: normal, successful completion ORA-16501: The Oracle Data Guard broker operation failed. ORA-16502: The Oracle Data Guard broker operation succeeded with warnings.

Usage Notes

• This function returns a binary integer.

Return Values

Error	Description
ORA-00000: normal, successful completion	The configuration was successfully removed.
Other	The Data Guard broker was unable to remove the configuration and the return value will indicate the reason for this failure.