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

Last updated on AUGUST 23, 2022

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.