EDIT DATABASE RESET (Parameter)

The EDIT DATABASE RESET (Parameter) command resets the specified database initialization parameter for the named database to its default value.

Format

EDIT DATABASE <db_unique_name> RESET PARAMETER <parameter_name>;

Command Parameters

db_unique_name

The DB_UNIQUE_NAME initialization parameter value of the database whose parameter value is to be reset.

parameter_name

The name of an existing database initialization parameter whose value that must be reset.

Command Example

The following example shows how to reset the log_archive_trace parameter for the database named South_Sales.

DGMGRL> EDIT DATABASE 'South_Sales' RESET PARAMETER log_archive_trace;
Succeeded.