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