The COPY_PLAN procedure is used to copy an existing resource management plan and its associated resource plan directives.
Syntax
DBMS_RESOURCE_MANAGER.COPY_PLAN (
source_plan IN VARCHAR2,
target_plan IN VARCHAR2,
comment IN VARCHAR2 DEFAULT '');
Parameters
| Parameter | Description |
|---|---|
| source_plan | The name of the source resource plan. |
| target_plan | The name of the target resource plan after the copy. The target resource plan must not already exist in the tenant. |
| comment | User comments |
Examples
Assume that two resource plans named SOURCE_PLAN and TARGET_PLAN have been created. Copy the SOURCE_PLAN and its associated resource plan directives to the TARGET_PLAN resource plan.
obclient(sys@oracle001)[SYS]> CALL DBMS_RESOURCE_MANAGER.COPY_PLAN(
SOURCE_PLAN => 'SOURCE_PLAN',
TARGET_PLAN => 'TARGET_PLAN');