|Oracle9i OLAP Developer's Guide to the OLAP DML
Release 2 (9.2)
Part Number A95298-01
Defining and Working with Analytic Workspaces, 8 of 9
You can export an entire workspace, several workspace objects, a single workspace object, or a portion of a workspace object to a specially formatted EIF file. Then you can import the information into a different workspace within the same Oracle database or a different one.
One reason for exporting and importing is to move your data to a new location. Another purpose is to remove extra space from your analytic workspace after you have added and then deleted many objects or dimension values. To do this, use the
EXPORT command to put all the data in an EIF file, create another workspace with a different name, and then use the
IMPORT command to import the EIF file into the new workspace. If you have imported into the same database, you can delete the old workspace and refer to the new one with the same workspace alias that you used for the original one.
The following command copies all the data and definitions from the current analytic workspace to an EIF file called
reorg.eif in a directory alias called
Directory aliases are defined in the database, and they control access to directories. You can use the
CDA command to specify a current directory alias. In this case, you do not have to specify a directory alias in the
EXPORT command, because Oracle OLAP assumes that you want the file to be created in your current directory alias. Contact your Oracle DBA for access rights to a directory alias where your database user name can read and write files.
The following command copies the data and definitions from the EIF file to a new analytic workspace.