Home > About Backing Up Dimensiona... > About Copying Analytic Work...
![]() Previous |
![]() Next |
You can copy analytic workspaces to replicate them on another computer or to back them up.
Data Pump: Analytic workspaces are copied with the other objects in a schema or database export. Use the expdp
/impdp
database utilities.
Tip: Verify that the target schema of an import has the OLAP_XS_ADMIN privilege. Otherwise, the analytic workspace will not be created with the necessary permissions. |
Transportable Tablespaces: Analytic workspaces are copied with the other objects to a transportable tablespace. However, you can only transport the tablespace to the same platform (for example, from Linux to Linux, Solaris to Solaris, or Windows to Windows) because the OLAP DECIMAL
data type is hardware dependent. Use the expdp
/impdp
database utilities. Transportable tablespaces are much faster than dump files.
The owner of an analytic workspace can export the schema to a dump file. Only users with the EXP_FULL_DATABASE
privilege or a privileged user (such as SYS
or a user with the DBA
role) can export the full database or create a transportable tablespace.
See Also: Oracle Database Utilities for information about Oracle Data Pump and theexpdp /impdp commands |