ORA-37002 and ORA-33262 'Analytic Workspace Express Does Not Exist' Errors During Conventional or Datapump Import (Doc ID 556130.1)

Last updated on JANUARY 27, 2016

Applies to:

Oracle OLAP - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

During a conventional import the following errors appear:

 

IMP-00003: ORACLE error 37002 encountered

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 67

ORA-06512: at "SYS.DBMS_AW", line 131

ORA-06512: at "SYS.DBMS_AW", line 787

ORA-06512: at "SYS.DBMS_AW", line 1157

ORA-06512: at "SYS.DBMS_AW", line 1141

ORA-06512: at "SYS.DBMS_AW_EXP", line 276

ORA-06512: at "SYS.DBMS_AW_EXP", line 227

ORA-06512: at line 289

Import terminated successfully with warnings.

 

 

During a Datapump Import (impdp) the following errors are received:

ORA-39083: Object type PROCACT_SCHEMA failed to create with error:

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

ORA-33262: Analytic workspace EXPRESS does not exist.

Failing sql is:

BEGIN

dbms_aw_exp.import_chunk112(1312, 'KioqKioqKioqKioqKioqKioqKioqKioqKgM

+ACIgVGhpcyBwcm9ncmFtIGVtcHRp

ZXMgdGhlIGNvbnRlbnRzIG9mIHRoZSBjdXJyZW50IGNtLmxvZ2ZpbGUsAyQAIiBz

byB0aGF0IGZyZXNoIGxvZ2dpbmcgY2FuIGJlIGRvbmUuA0kAIiAqKioqKioqKioq

KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKio



.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms