Oracle 12cR2 DBMS_CUBE_ADVISE

Oracle DBMS_CUBE_ADVISE_SEC Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.

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

CHECK_FOR_NESTING	COADSEQ_CURRENT	GET_MVNAME
CHECK_TABLE_ACCESS	COADSEQ_NEXT	GET_NN_NAME

CHECK_FOR_NESTING

Undocumented dbms_cube_advise_sec.check_for_nesting( mvowner IN VARCHAR2, mvname IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF dbms_cube_advise_sec.check_for_nesting(USER, 
      'SYS') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

CHECK_TABLE_ACCESS

Undocumented dbms_cube_advise_sec.check_table_access( table_owner IN VARCHAR2, table_name IN VARCHAR2) RETURN BINARY_INTEGER;

SELECT dbms_cube_advise_sec.check_table_access(USER, 'TAB$')

      FROM dual;

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

GET_MVNAME

Undocumented

The target must be a cube dbms_cube_advise_sec.get_mvname( owner IN VARCHAR2, objname IN VARCHAR2, objhier IN VARCHAR2); RETURN VARCHAR2;

conn uwclass/uwclass@pdbdev

      

      SELECT dbms_cube_advise_sec.get_mvname('UWCLASS', 
      'TEST_CUBE_MV')

      FROM dual;

GET_NN_NAME

Undocumented

The target must be a cube dbms_cube_advise_sec.get_nn_name( tabowner IN VARCHAR2, tabname IN VARCHAR2, colname IN VARCHAR2); RETURN VARCHAR2;

SELECT dbms_cube_advise_sec.get_nn_name('UWCLASS', 'TEST_CUBE_MV', 'TRANS_DATE')

      FROM dual;