Alter 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. For example, the following statement changes table tabnolog to a STANDARD table:
ALTER TABLE tabnolog TYPE (STANDARD)
Important: When you alter a table to STANDARD, you turn logging on for that table. After you alter the table, perform a level-0 backup if you must be able to restore the table.

Copyright© 2019 HCL Technologies Limited