When you create a partition definition, the information for the partition is stored in two .ddb files—one in the database directory of the source and the other in the database directory of the target. If the connection information stored in one of these .ddb files is invalid, the partition needs to be repaired before you can open and edit it from Enterprise View. A partition cannot be restored if one of the .ddb files for the source or target is physically missing (for example, if the application or database is deleted using a tool other than Administration Services).
In general, if you rename, copy, or delete applications and databases that contain partitions using Administration Services, the corresponding partition definitions are updated or removed automatically to reflect the change.
Partitions may need repair in the following cases:
If applications or databases are renamed or copied using a different tool (such as MaxL), Administration Services may not be able to find the corresponding .ddb file for the second half of the partition. If for any reason Administration Services cannot determine both the source and target for the partition, the partition is displayed under the Orphan Partitions node in Enterprise View so that you can repair or delete it. If both .ddb files exist in their expected locations but are invalid, you can select the source or target partition under the Source Database or Target Database node in Enterprise View and repair the invalid information.
Note: | This functionality is available only if you are connecting to a Release 6.5.3 or higher Essbase Server. |
To repair a partition:
From Enterprise View or a custom view, select a database.
Under the Partitions node, find the source or target partition definition that you want to repair, or find the partition definition under the Orphan Partitions node.
Right-click the partition and select Repair partition.
The Repair Partition dialog box opens. Only fields that need repair are editable.
Edit the invalid fields, and click Repair.
Essbase saves the corrected information to the .ddb partition definition file.
To edit the partition after the repair is complete, right-click the partition in Enterprise View and select Edit partition.
If an invalid partition cannot be repaired and you want to delete the available half of the partition, right-click the partition in Enterprise View and select Delete partition.
“Designing Partitioned Applications” in the Oracle Essbase Database Administrator's Guide
“Creating and Maintaining Partitions” in the Oracle Essbase Database Administrator's Guide
alter partition (MaxL) in the Oracle Essbase Technical Reference
drop partition with force (MaxL) in the Oracle Essbase Technical Reference