Switching Between Table Types

Use the ALTER TABLE command to switch between types of permanent tables. If the table does not meet the restrictions of the new type, the alter fails and produces an explanatory error message. The following restrictions apply to table alteration:

• You must drop indexes and referential constraints before you alter a table to a RAW type.
• You must perform a level-0 archive before you alter a table to a STANDARD type, so that the table meets the full recoverability restriction.
• You cannot alter a temp or scratch temporary table.