My Oracle Support Banner

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

Last updated on AUGUST 23, 2022

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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