ORA-33263: Could Not Create Analytic Workspace SYS.EXPRESS (Doc ID 1082283.1)

Last updated on JULY 07, 2017

Applies to:

Oracle OLAP - Version: 10.2.0.1 to 11.2.0.3 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

You are receiving the following error while running olap.sql  script to add Olap option to a database that had Olap option before or a previous failed attempt:

BEGIN dbms_aw_build.build('AWMD', TRUE); END;

*
ERROR at line 1:
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.
ORA-33263: Could not create analytic workspace SYS.EXPRESS
ORA-33269: while operating on 'SYS.AW$EXPRESS'
ORA-00955: name is already used by an existing object
ORA-06512: at "SYS.DBMS_AW_BUILD", line 107
ORA-06512: at line 1


BEGIN dbms_aw_build.build('AWCREATE', TRUE); END;

*
ERROR at line 1:
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.
ORA-33263: Could not create analytic workspace SYS.EXPRESS
ORA-33269: while operating on 'SYS.AW$EXPRESS'
ORA-00955: name is already used by an existing object
ORA-06512: at "SYS.DBMS_AW_BUILD", line 107
ORA-06512: at line 1


Changes

You removed Olap option from the database.

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