Database Utilities (MOSC)

MOSC Banner

Exclude analytic workspace from export (expdp)

edited Jun 17, 2014 12:00PM in Database Utilities (MOSC) 4 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center