The DROP clause

When you define a fragmentation strategy, you must drop one or more fragments. With , you can use the DROP clause of the ALTER FRAGMENT ON TABLE statement to drop a fragment from a table. Suppose you want to drop a fragment from a table that you create with the following statement:

CREATE TABLE sales (col_a INT), ...) 
   FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace2, dbspace3;

The following ALTER FRAGMENT statement uses a DROP clause to drop the third fragment dbspace3 from the sales table:

ALTER FRAGMENT ON TABLE sales DROP dbspace3;