My Oracle Support Banner

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 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)
  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.

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

PL/SQL procedure successfully completed.


Upgrade from 10g to 11g.


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

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