From a partitioned table to a nonpartitioned table

 

The DROP PARTITIONING clause changes a partitioned table to a nonpartitioned table.

If the specified table is already nonpartitioned, an error is returned. Changing a partitioned table that contains data into a nonpartitioned table requires data movement between the data partitions. You cannot change a partitioned table whose size is larger than the maximum nonpartitioned table size to a nonpartitioned table.

 

Parent topic:

Modification of existing tables