15. Performing Backup and Recovery : Recovery : Table Recovery Using Roll Forward
 
Share this page                  
Table Recovery Using Roll Forward
You can specify that only certain tables are recovered during a roll forward database operation. (Journals of tables in the database must be enabled.) When doing table-level recovery, you can optionally move the table to a new location.
Note:  The database must be extended to the new locations before the rollforward.
The format for recovering tables is as follows:
rollforwarddb dbname[/server_class]
  [-table=tablename {, tablename}
  [-nosecondary_index] [-on_error_continue]
  [-relocate -location=locationname {, locationname}
   -new_location=locationname {, locationname}]]
Note:  Table recovery is not allowed if structural changes have been made to the table after the checkpoint (that is, if you have modified the table, created indexes, or altered the number of columns in the table).