Analytic workspace failed due to ORA-33272 and ORA-01426 (Doc ID 2936880.1)

Last updated on MAY 16, 2023

Applies to:

Symptoms

Getting below error while trying to recreate the OLAP Aws.

SQL> exec dbms_aw.execute('aw create ZPB.ZPBCODE');
BEGIN dbms_aw.execute('aw create ZPB.ZPBCODE'); END;

*
ERROR at line 1:
ORA-33272: Analytic workspace ZPB.ZPBCODE cannot be opened.
ORA-01426: numeric overflow
ORA-06512: at "SYS.DBMS_AW", line 127
ORA-06512: at "SYS.DBMS_AW", line 156
ORA-06512: at line 1

Changes

After recreate the OLAP analytical workspaces

Cause

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