The ENABLE statement enables the scheduled partition balancing feature.
Syntax
DBMS_SCHEDULER.ENABLE('SCHEDULED_TRIGGER_PARTITION_BALANCE');
Limitations and considerations
When you enable the SCHEDULED_TRIGGER_PARTITION_BALANCE task, you must set the tenant-level parameter partition_balance_schedule_interval to 0. Otherwise, the system returns the OB_OP_NOT_ALLOW error. You cannot enable both the parameter trigger and the scheduled task trigger.
Examples
obclient> CALL DBMS_SCHEDULER.ENABLE('SCHEDULED_TRIGGER_PARTITION_BALANCE');
Query OK, 0 rows affected (0.010 sec)