ORA-33292 When Accessing Analytic Workspace From PL/SQL Subprogram
Last updated on JUNE 06, 2017
Applies to:Oracle OLAP - Version 18.104.22.168 and later
Information in this document applies to any platform.
When executing Analytic Workspace (AW) operation via PL/SQL function or procedure
ORA-33292: Insufficient permissions to access analytic workspace error occurs.
This tends to happen with AW having 10g version of metadata in 11g Release 2, and may be accompanied with ORA-600 error message.
SQL> create or replace procedure aw_truncate (aw IN VARCHAR2)
4 DBMS_AW.EXECUTE ('aw truncate ' || aw);
SQL> exec aw_truncate('FLEET_10g');
BEGIN aw_truncate('FLEET_10g'); END;
ERROR at line 1:
ORA-00600: internal error code, arguments: [KSSRMP1], , , , , , , , , , , 
ORA-33292: Insufficient permissions to access analytic workspace GLOBAL.FLEET_10G using the specified
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122
ORA-06512: at "GLOBAL.AW_TRUNCATE", line 4
ORA-06512: at line 1
When executing the same operation in PL/SQL anonymous block as the same user, operation completes without error.
2 DBMS_AW.EXECUTE ('aw truncate fleet_10g');
PL/SQL procedure successfully completed.
Upgrade from 10g to 11g.
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