Oracle DBMS_CUBE_ADVISE_SEC
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
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
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;

Related Topics
DBMS_CUBE
DBMS_CUBE_LOG
DBMS_CUBE_UTIL
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved