Oracle | DBMS_CUBE_ADVISE

Oracle DBMS_CUBE_ADVISE_SEC Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Undocumented

AUTHID DEFINER

Dependencies

DBMS_CUBE_ADVICE_SEQ$

DBMS_CUBE_ADVISE

DBMS_STANDARD

Documented No

Exceptions

Error Code	Reason
ORA-08002	dbms_cube_advice_seq$.currval not yet defined in the session
ORA-20103	invalid cube name, SYS.TAB$

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

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

Subprograms

COADSEQ_CURRENT

COADSEQ_NEXT

COADSEQ_CURRENT

Undocumented dbms_cube_advise_sec.coadseq_current RETURN VARCHAR2;

SELECT dbms_cube_advise_sec.coadseq_current

      FROM dual;

             *

      ERROR at line 1:

      ORA-08002: sequence DBMS_CUBE_ADVICE_SEQ$.CURRVAL is not yet defined in 
      this session

      ORA-06512: at "SYS.DBMS_CUBE_ADVISE_SEC", line 221

If you run coadseq_next first returns a "1"

COADSEQ_NEXT

Undocumented dbms_cube_advise_sec.coadseq_next RETURN VARCHAR2;

SELECT dbms_cube_advise_sec.coadseq_next

      FROM dual;

      

      COADSEQ_NEXT

      ------------

                 1