Importing and Exporting Workspace Objects

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 mydir.

export all to eif file 'mydir/reorg.eif'

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.

aw create new
import all from eif file 'reorg.eif'
update
commit