9482 DROP RANGE/ADD RANGE clause has no corresponding level that is a RANGE_N function.
Explanation:
For an ALTER TABLE statement altering ranges, the first alter ranges clause (DROP RANGE and/or ADD RANGE) when it doesnt specify a specific level defaults to apply to the first level that has a partitioning expression consisting solely of a RANGE_N function but no such level occurs in the existing partitioning. Or, if not the first alter ranges clause, it defaults to apply to the next level after the default or specified level of the preceding alter ranges clause that has a partitioning expression consisting solely of a RANGE_N function but no such level occurs in the remaining levels of existing partitioning.
Generated By:
RES module.
For Whom:
End User.
Remedy:
Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the multilevel partitioning rules and resubmit the request.