Altering Partitioning Table into Regular Table

Description

To alter an existing partitioned table into a regular one, use the ALTER TABLE statement.

Syntax

ALTER {TABLE | CLASS} <table_name>

REMOVE PARTITIONING

• table_name : Specifies the name of the table to be altered.

Example

The following is an example of altering the partitioned table of name "nation2" into a regular one.

ALTER TABLE nation2 REMOVE PARTITIONING;