Converting an Analytic Workspace to Oracle 11g Storage Format

Analytic workspaces are stored in tables within the database. The storage format for Oracle 11g analytic workspaces is different from the storage format used in Oracle10g. Analytic workspace storage format is described in Oracle OLAP User's Guide.

When you upgrade an Oracle10g database to Oracle 11g, the upgraded database is automatically in Oracle9i compatibility mode, and the analytic workspaces are still in Oracle10g storage format. If you want to use new Oracle 11g OLAP features, you must use DBMS_AW.CONVERT to convert these workspaces to the new storage format.

See Also:

Procedure: Convert an Analytic Workspace to the Latest Storage Format

To convert an analytic workspace to a more recent storage format, follow these steps:

  1. Change the compatibility mode of the database to 11.0.0 or higher.

  2. Log into the database with the identity of the analytic workspace.

  3. In SQL*Plus, convert the workspace to the current format:

    EXECUTE dbms_aw.convert ('my_aw');
  4. Because you changed the database compatibility mode to Oracle Database 11g, any new workspaces that you create are in the new storage format.

Procedure: Import an Analytic Workspace from an Older Release of Oracle Database into a Newer Release of the Database

If you install Oracle Database 11g separately from your old Oracle Database installation, you can export the analytic workspaces from the older release and import them into Oracle Database 11g. The export and import processes automatically convert the workspaces to the new storage format. Therefore you do not need to use DBMS_AW.CONVERT in this case.

Use the following procedure to export an Oracle9i analytic workspace and import it in an Oracle 11g database.

In Oracle9i SQL*Plus, export the analytic workspace to the directory identified by the work_dir directory object.

EXECUTE dbms_aw.execute ('AW ATTACH ''awname''');
EXECUTE dbms_aw.execute ('ALLSTAT');
EXECUTE dbms_aw.execute ('CDA work_dir');
EXECUTE dbms_aw.execute ('EXPORT ALL TO EIF FILE ''filename''');

In Oracle 11g SQL*Plus, create a new workspace with the same name and schema, and import the EIF file from the work_dir directory.

EXECUTE dbms_aw.execute ('AW CREATE awname');
EXECUTE dbms_aw.execute ('CDA work_dir');
EXECUTE dbms_aw.execute ('IMPORT ALL FROM EIF FILE ''filename''');
EXECUTE dbms_aw.execute ('UPDATE');

You can also use Oracle export and import utilities to move the entire schema, including the analytic workspaces to an Oracle 10g database. See Oracle Database Utilities and Oracle Database Upgrade Guide.