Oracle DBMS_CUBE_ADVISE_SEC
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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