Restrictions on the ALTER FRAGMENT Statement

You cannot use the ALTER FRAGMENT statement on a view, on a temporary table, or on a table that is not registered in the current database.

If your table or index is not already fragmented, the only clauses available to you are ATTACH and INIT.

You cannot use ALTER FRAGMENT on a typed table that is part of a table hierarchy.