EDIT DATABASE (Parameter)

The EDIT DATABASE (Parameter) command sets the specified initialization parameter for the named database.

Format

EDIT DATABASE <db_unique_name> SET PARAMETER <parameter_name> = value  [initialization_parameter_options]

Command Parameters

db_unique_name

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

parameter_name

The name of the existing database initialization parameter that must be modified.

value

The new value for the parameter.

initialization_parameter_options

Additional initialization parameter options must be enclosed within single quotes. Use one or both of the following options:

• SCOPE: Set one of the following values for scope: SPFILE, MEMORY, or BOTH. The default value is BOTH. If the specified parameter is a static parameter, then set SCOPE= SPFILE.

• SID: Specify the name of a database instance for which the parameter must be set. If the specified parameter must be set for all instances, set SID=’*’.

  Note:

  Because the 'SID=...' clause must be contained within single quotes itself, the single quotes around '*' for the all instances case must be escaped by using '\' characters as in this example to avoid a syntax error:

  DGMGRL> edit database dglcp3 set parameter log_archive_trace=65535 
           'SID=\'*\''; Parameter "log_archive_trace" updated for member "dglcp3".

Usage Notes

The database must be available when this command is run.

Command Example

The following example edits the initialization parameter log_archive_trace for the database named North_sales and sets its value to 1. The SCOPE setting specifies that the parameter must be changed in both the memory and in the database initialization parameter file.

DGMGRL> EDIT DATABASE 'North_sales' SET PARAMETER log_archive_trace = 1 'SCOPE = BOTH';