ORA-33292 When Accessing Analytic Workspace From PL/SQL Subprogram (Doc ID 1404193.1)

Last updated on JUNE 06, 2017

Applies to:

Oracle OLAP - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

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>conn GLOBAL
SQL> create or replace procedure aw_truncate (aw IN VARCHAR2)
  2  IS
  3  BEGIN
  4  DBMS_AW.EXECUTE ('aw truncate ' || aw);
  5  END;
  6  /

Procedure created.

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
access mode.
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.

SQL> BEGIN
  2       DBMS_AW.EXECUTE ('aw truncate fleet_10g');
  3    END;
  4   /

PL/SQL procedure successfully completed.

Changes

Upgrade from 10g to 11g.

Cause

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