Restrictions

If you fragment a table with range fragmentation, you cannot perform the following operations on the table after it is created:

• You cannot change the fragmentation strategy (ALTER FRAGMENT).
• You cannot rename the columns of the table (RENAME COLUMN).
• You cannot alter the table in any way except to change the table type or to change the lock mode.

That is, the Usage-TYPE options and the Lock Mode clause are the only valid options of ALTER TABLE for a table that has range fragmentation.