Exclude analytic workspace from export (expdp)
Using Oracle 11.2.0.4 on Windows 2008R2 servers
I would like to do a full export of a data warehouse database containing analytic workspaces and OLAP cubes. It is very troublesome to export AW (AW$ objctes). I have tried to
Therefore, I would like to exclude the analytical workspace (AW$) from the export.
I have tried something like this in the parameter file :
EXCLUDE=TABLE:"like '%AW$%'"
EXCLUDE=TABLE PARTITION:"like '%AW$%'"
EXCLUDE=TABLE SUBPARTITION:"like '%AW$%'"
The above EXclude does not work well from a full export :
ORA-39001: invalid argument value
ORA-39038: Object path "PARTITION" is not supported for FULL jobs.