ORA-33262: Analytic workspace EXPRESS does not exist

ORA-39127 ORA-37002 ORA-33262 During Expdp After Upgrade To 10g. No Errors If Using Exp [ID 741232.1]
 

During expdp (export datapump) the following errors occurred:

ORA-39127: unexpected error from call to export_string :=SYS.DBMS_AW_EXP.schema_info_exp('
SYS',1,1,'09.02.00.00.00',newblock)
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.
ORA-33262: Analytic workspace EXPRESS does not exist.
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122
ORA-06512: at "SYS.DBMS_AW_EXP", line 473
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5419

Cause

Uninstalled or incomplete install of OLAP objects results in:

ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.

Solution

1) Relink Oracle with the OLAP option turned off (olap_off make target)

-OR-

2) Remove the relevant entries from exppkgact$:

DELETE FROM sys.exppkgact$ WHERE package='DBMS_AW_EXP';