The ENABLE procedure enables scheduled partition balancing.
Syntax
DBMS_SCHEDULER.ENABLE('SCHEDULED_TRIGGER_PARTITION_BALANCE');
Considerations
To enable the scheduled partition balancing job named SCHEDULED_TRIGGER_PARTITION_BALANCE, make sure that the tenant-level parameter partition_balance_schedule_interval is set to 0. Otherwise, the following error will be returned: OB_OP_NOT_ALLOW. If partition balancing has been enabled by using a parameter, you cannot enable the scheduled partition balancing job.
Examples
obclient> CALL DBMS_SCHEDULER.ENABLE('SCHEDULED_TRIGGER_PARTITION_BALANCE');
Query OK, 0 rows affected (0.010 sec)