Use a single nonfragmented table

To create a fragmented table from a nonfragmented table, use the INIT clause of the ALTER FRAGMENT statement. For example, suppose you want to convert the table orders to a table fragmented by round-robin. The following SQL statement performs the conversion:

ALTER FRAGMENT ON TABLE orders INIT 
   FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace2, dbspace3;