Oracle | DBMS_CUBE_PRVTEXP

Oracle DBMS_CUBE_PRVTEXP Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Undocumented but definitely for OLAP and likely related to cube export.

AUTHID CURRENT_USER

Dependencies

DBMS_CUBE	DBMS_XSLPROCESSOR	RESOURCE_VIEW
DBMS_CUBE_EXP	DBMS_ZHELP	UNDER_PATH
DBMS_XDB	EQUALS_PATH	XMLTYPE

Documented No

First Available 20c

Security Model Owned with an SYS with EXECUTE granted to PUBLIC

Direct access to this package is prevented by an Accessible By clause.

Source {ORACLE_HOME}/olap/admin/olapipexxdb.plb

Subprograms

ANC_PATHS_CURSOR_ISOPEN	FETCH_ANC_PATHS_CURSOR	GET_OBJECT_GRANTS
CLOB2FILE	GETCONTENTCLOB	GET_RESOURCE_NAME
CLOSE_ANC_PATHS_CURSOR	GET_DS_DOC	OPEN_ANC_PATHS_CURSOR
EXISTSRESOURCE

ANC_PATHS_CURSOR_ISOPEN

Undocumented dbms_cube_prvtexp.anc_paths_cursor_isopen RETURN BOOLEAN;

Protected with an ACCESSIBLE BY clause

CLOB2FILE (new 23ai)

Writes a CLOB to a file dbms_cube_prvtexp.clob2file( cl IN CLOB, flocation IN VARCHAR2, fname IN VARCHAR2);

Protected with an ACCESSIBLE BY clause

CLOSE_ANC_PATHS_CURSOR

Undocumented dbms_cube_prvtexp.close_anc_paths_cursor;

Protected with an ACCESSIBLE BY clause

Undocumented dbms_cube_prvtexp.existsResource(ds_path IN VARCHAR2) RETURN BOOLEAN;

Protected with an ACCESSIBLE BY clause

FETCH_ANC_PATHS_CURSOR

Undocumented dbms_cube_prvtexp.fetch_anc_paths_cursor( ds_anc_path OUT VARCHAR2, notfound OUT BOOLEAN);

Protected with an ACCESSIBLE BY clause

GETCONTENTCLOB (new 23ai)

Reads a file into a CLOB variable dbms_cube_prvtexp.getContentClob(abspath IN VARCHAR2) RETURN CLOB;

Protected with an ACCESSIBLE BY clause

Undocumented dbms_cube_prvtexp.get_ds_doc(ds_path IN VARCHAR2) RETURN VARCHAR2;

Protected with an ACCESSIBLE BY clause

GET_OBJECT_GRANTS

Undocumented but appears to return

Protected with an an ACCESSIBLE with an clause dbms_cube_prvtexp.get_object_grants( obj_id IN NUMBER, cascade IN BOOLEAN, grantor OUT VARCHAR2, grantee OUT VARCHAR2, grant_option OUT BINARY_INTEGER, priv OUT NUMBER, obj_schema OUT VARCHAR2, obj_name OUT VARCHAR2, state IN OUT BOOLEAN);

SELECT object_id

      FROM dba_objects

      WHERE object_name = 'PDB_ARC_SKIP$';

      

      DECLARE

       b BOOLEAN := TRUE;

       x NUMBER;

       z dbms_id;

      BEGIN

        dbms_cube_prvtexp.get_object_grants(261, b, z, z, x, x, z, z, b);

        dbms_output.put_line(z);

      END;

      /

      dbms_cube_prvtexp.get_object_grants(261, b, z, z, x, x, z, z, b);

      *

      ERROR at line 6:

      ORA-06550: line 6, column 3:

      PLS-00904: insufficient privilege to access object DBMS_CUBE_PRVTEXP

      ORA-06550: line 6, column 3:

      PL/SQL: Statement ignored

GET_RESOURCE_NAME

Undocumented dbms_cube_prvtexp.get_resource_name( ds_path IN VARCHAR2, ds_doc IN VARCHAR2) RETURN VARCHAR2;

Protected with an ACCESSIBLE BY clause

OPEN_ANC_PATHS_CURSOR

Undocumented dbms_cube_prvtexp.open_anc_paths_cursor(path IN VARCHAR2);

Protected with an ACCESSIBLE BY clause

Related Topics

Built-in Functions

Built-in Packages

Database Security

What's New In 21c

What's New In 26ai

Morgan's Library Page Footer

This site is maintained by Daniel Morgan. Last Updated:

This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved