Oracle Version : 12.1.0.2
When I tried to create a data cube using
DECLARE
event_aw varchar2(30);
BEGIN
event_aw := dbms_cube.create_mview('DWH', 'DC_CUBE_2_MV', 'build=immediate');
END;
/
I got the following error:
ORA-20332: No dimensions found in materialized view "DWH.DC_CUBE_2_MV". At least one simple column is required in select list and GROUP BY
clause and all key columns must be unique. Aliasing may cause this unique dimension level key violation.
ORA-06512: at "SYS.DBMS_CUBE", line 10875
ORA-06512: at line 5
I already have a data cube created on the same table and the same dimensions (2 dimensions)
the new data cube I am trying to create is just having additional column than the existing one. But it failed.
I don't understand what the error above mean since there are dimensions in the materialized view and a cube already created when it was version of 11.2.0.4