My Oracle Support Banner

DBMS_CUBE Is Invalid After Running Olapiboo.plb (Doc ID 2891423.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

After running olapiboo.plb as described in Invalid DBMS_CUBE_EXP (Doc ID 2017988.1), DBMS_CUBE is Invalid

Log file shows:

fixolap.log is the log file from running SQL> @?/olap/admin/olapiboo.plb


Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY DBMS_CUBE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
10630/12 PL/SQL: Statement ignored
10630/16 PLS-00201: identifier 'SYS.DBMS_CUBE_ADVISE' must be declared
11018/4 PL/SQL: Statement ignored
11018/18 PLS-00201: identifier 'SYS.DBMS_CUBE_ADVISE' must be declared
11022/6 PL/SQL: Statement ignored
11022/20 PLS-00201: identifier 'SYS.DBMS_CUBE_ADVISE' must be declared

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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