Chapter 7 Denormalizing a PDM

Revert a vertical partitioning

The revert feature is used to recover the original table used for partitioning. This procedure does not apply if you have kept the original table.

Revert is not a single-click operation, you have to perform several actions as described in the procedure below. Revert is only accessible if the partitioned table is a generated object proceeding from a PDM, CDM, or OOM generation into a PDM, otherwise you will not be able to recover the partitioned table.

To revert a vertical partitioning:

1. Select a vertical partitioning object in the List of Transformations.
2. Click the Cancel Transformation tool in the list toolbar in order to initiate the revert process.
   
   
      Cancel Transformation tool
   The Cancel Transformations tool is disabled if the table is not a generated object
   
   
   
   The vertical partitioning object is removed from the list.
3. Click OK.
   
   The vertical partitions and their corresponding tables are deleted from the PDM.
4. Regenerate the PDM in update mode.
   
   Since the transformation object is no longer in the model, the merge dialog box lets you recreate the original table used for the partitioning. You have reverted the vertical partitioning.

Copyright (C) 2005. Sybase Inc. All rights reserved.