Home |
Previous Page | Next Page Logging and Log Administration > Managing the Database-Logging Mode > Modifying the Table-Logging Mode >
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)
Warning:
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 need to be able to restore the table.
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]