8. SQL Statements : MODIFY : Modify...to Phys_consistent|Phys_inconsistent
 
Share this page                  
Modify...to Phys_consistent|Phys_inconsistent
A physically inconsistent table has some form of physical corruption. A table is marked physically inconsistent if rollforwarddb of that table fails for some reason, or if the table is a secondary index and point-in-time recovery has occurred only on the base table.
The MODIFY...TO PHYS_CONSISTENT command marks the table as physically consistent but does not change the underlying problem.