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  
AUTHID DEFINER
Dependencies
ATTRCOL$ DBMS_PRIV_CAPTURE OLAP_IMPL_OPTIONS$
CCOL$ DBMS_STANDARD PLITBLM
CDEF$ DBMS_UTILITY SUMKEY$
COL$ OBJ$ SYSAUTH$
CON$ OBJAUTH$ USER$
DBA_OBJECTS OLAP_CUBES$ V$ENABLEDPRIVS
DBMS_CUBE OLAP_CUBE_DIMENSIONS$ X$KZSRO
DBMS_CUBE_ADVICE_SEQ$ OLAP_HIERARCHIES$ _CURRENT_EDITION_OBJ
DBMS_CUBE_ADVISE    
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