The COPY_PLAN procedure is used to copy an existing resource management plan and its associated resource plan instructions.
Syntax
DBMS_RESOURCE_MANAGER.COPY_PLAN (
source_plan VARCHAR(65535),
target_plan VARCHAR(65535),
comment VARCHAR(65535) 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 cannot be an existing resource plan in the tenant. |
| comment | User comments |
Examples
Assume that two resource plans named SOURCE_PLAN and TARGET_PLAN have been created. The SOURCE_PLAN and its corresponding resource plan instructions are copied to the TARGET_PLAN resource plan.
obclient(root@mysql001)[(none)]> CALL DBMS_RESOURCE_MANAGER.COPY_PLAN(
SOURCE_PLAN => 'SOURCE_PLAN',
TARGET_PLAN => 'TARGET_PLAN',
COMMENT => 'copy plan from SOURCE_PLAN');