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
