Exporting Databases

For databases for which you have Read permission, you can back up data by exporting it to text files. Exported data is not compressed. Export files contain only data—not control, outline, or security information.

If the database that you are exporting is not running, Administration Services starts it. During data export, users can connect to and perform read-only operations on the database.

Note:

When you export data from databases that contain duplicate member names, the qualified names for duplicate members are exported. In export files, all member names are enclosed in quotation marks (“ ”).

  To export databases:

  1. From Enterprise View or a custom view, select a database.

  2. Right-click, and select Export.

  3. In the Export Database Dialog Box dialog box, specify the name for the export file or files.

  4. Select the data to export.

    Note:

    For aggregate storage databases, you can export only level 0 data.

  5. Optional: To export data in a columnar format, select Export in column format.

    Note:

    This option does not apply to aggregate storage databases.

  6. Optional: To export data in the background, so you can work in the console as the export processes, select Execute in the background.

  7. Click OK.

    Essbase runs the export. Errors and status messages are displayed in the Messages pane, at the bottom of the console window. If you export in the background, an ID for the process is displayed. You can use the ID to track the status of the export in the Background Process Status window.

    Note:

    By default, Administration Services exports the database to the file system of the selected Essbase Administration Server, not to your local file system.

Related Information

  • Export Database Dialog Box

  • “Export Backups” in the Oracle Essbase Database Administrator's Guide (block storage)

  • “Exporting Aggregate Storage Databases” in the Oracle Essbase Database Administrator's Guide (aggregate storage)

Related Commands

  • export data block storage (MaxL) in the Oracle Essbase Technical Reference

  • export data aggregate storage (MaxL) in the Oracle Essbase Technical Reference

  • export (ESSCMD) in the Oracle Essbase Technical Reference