You use the Copy Partition dialog box to copy partitions and to specify connection information for source and target databases.
You can copy a partition between a new or existing source database and a new target database but not between a new source database and an existing target database.
Information that is provided and actions that can be performed in the Data Source and Data Target areas (relative to the source and target database, respectively):
Essbase Server—Name of the Essbase Server instance on which the database resides. You can select a different Essbase Server instance.
Application—Name of the application in which the database resides. You can select a different application.
Database—Name of the database in which the partition resides. You can select a different database.
User and Password—Username and password that the partition uses to connect to the server that contains the database. Essbase uses the username and password to transfer data between the source and target databases for replicated and transparent partitions. Local security filters apply to prevent end users from seeing privileged data.
For source databases, you cannot specify a username and password.
For target databases, you can specify a username and password. Essbase
Comment—An explanatory note. You can modify or enter a note. For linked partitions, the comment text is displayed in Spreadsheet Add-in in the Linked Objects box.
alter object (MaxL) in the Oracle Essbase Technical Reference