Altering a Table to Turn On Logging

Home | Previous Page | Next Page Logging and Log Administration > Managing Database-Logging Status > Modifying the Table-Logging Status >

Altering a Table to Turn On Logging

To switch from a nonlogging table to a logging table, use the SQL statement ALTER TABLE with the TYPE option of STANDARD or OPERATIONAL. For example, the following statement changes table tabnolog to a STANDARD table:

ALTER TABLE tabnolog TYPE (STANDARD)

Warning:

When you alter a table to STANDARD or OPERATIONAL from any other table type, you turn logging on for that table. After you alter the table, perform a level-0 backup if you need to be able to restore the table.