You can copy a partition to a new location if the outlines for the source and target databases of the new partition are identical to the outlines for the source and target databases of the existing partition.
You can copy a partition to a new source database and a new target database, or you can copy the partition to the existing source and a new target.
Note: | You cannot copy a partition to a new source and an existing target. |
The partition is validated before copying. If the validation detects errors, the partition is not copied. If warnings are detected, you are prompted to continue or cancel the copy operation.
To copy partitions:
From Enterprise View or a custom view, select a source database.
Under the database node, expand the Partitions node.
Select a partition.
Right-click and select Copy partition.
In the Copy Partition dialog box, perform the following:
Select the Essbase Server, application, and database of the data source to which you are copying the partition.
Select the Essbase Server, application, database, user, and password of the data target to which you are copying the partition.
Optional: In the Comments text box, enter comments.
Click OK.
alter object (MaxL) in the Oracle Essbase Technical Reference