Kbase P145880: Is it safe to use the force (-F) option to access a database after stopping a delete table operation
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/6/2009 |
|
Status: Unverified
GOAL:
Is it safe to use the force (-F) option to access a database after stopping a delete table operation if the area where the table resides is going to be truncated?
GOAL:
If a delete table operation is interrupted, is it safe to force access to the database (using the -F option) to avoid a long transaction undo if the area where the table resides is about to be truncated?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
No. The operation of deleting a table makes changes to the database's schema tables. Not all changes are made in succession. If the delete table operation is interrupted and the -F option is then used to force access into the database, the changes made to the schema are not allowed to be undone. It is possible that some schema tables will have references to the table being deleted, while others will not. Inconsistencies in the database schema can have an unknown affect on future schema modifications or other operations, such as index build. It is generally advised never to use the -F option to force access to a database unless you are able to then perform a dump and load of the data.