alter table...unpartition Syntax

Unpartitioning a table concatenates the table’s multiple partitions into a single partition. Unpartitioning a table does not change the location of the data.

The syntax for using the unpartition clause to alter table is:

alter table table_name unpartition

For example, to unpartition a table named historytab, enter:

alter table historytab unpartition