ENABLE

The ENABLE procedure enables the scheduled partition balancing feature.

Syntax

DBMS_SCHEDULER.ENABLE('SCHEDULED_TRIGGER_PARTITION_BALANCE');

Limitations and considerations

When you enable the scheduled partition balancing task SCHEDULED_TRIGGER_PARTITION_BALANCE, the tenant-level parameter partition_balance_schedule_interval must be set to 0. Otherwise, the system returns an error OB_OP_NOT_ALLOW. The configuration item trigger and the scheduled task trigger cannot be enabled at the same time.

Examples

obclient> CALL DBMS_SCHEDULER.ENABLE('SCHEDULED_TRIGGER_PARTITION_BALANCE');
Query OK, 0 rows affected

References

• partition_balance_schedule_interval