DBA Data[Home] [Help]

SYS.DBMS_AW dependencies on DBMS_AW$_DIMENSION_SOURCES_T

Line 80: sources IN OUT dbms_aw$_dimension_sources_t,

76: PROCEDURE sparsity_advice_table(tblname IN VARCHAR2 DEFAULT NULL);
77:
78: PROCEDURE add_dimension_source(dimname IN VARCHAR2,
79: colname IN VARCHAR2,
80: sources IN OUT dbms_aw$_dimension_sources_t,
81: srcval IN VARCHAR2 DEFAULT NULL,
82: dimtype IN NUMBER DEFAULT NO_HIER,
83: hiercols IN dbms_aw$_columnlist_t
84: DEFAULT NULL,

Line 90: dimsources IN dbms_aw$_dimension_sources_t,

86: DEFAULT PARTBY_DEFAULT);
87:
88: PROCEDURE advise_sparsity(fact IN VARCHAR2,
89: cubename IN VARCHAR2,
90: dimsources IN dbms_aw$_dimension_sources_t,
91: advmode IN BINARY_INTEGER
92: DEFAULT ADVICE_DEFAULT,
93: partby IN BINARY_INTEGER
94: DEFAULT PARTBY_DEFAULT,

Line 109: dimsources IN dbms_aw$_dimension_sources_t,

105: sparsename IN VARCHAR2 DEFAULT NULL,
106: dtype IN VARCHAR2 DEFAULT 'NUMBER',
107: advtable IN VARCHAR2 DEFAULT NULL);
108: FUNCTION advise_partitioning_dimension(cubename IN VARCHAR2,
109: dimsources IN dbms_aw$_dimension_sources_t,
110: advtable IN VARCHAR2 DEFAULT NULL)
111: RETURN VARCHAR2;
112: FUNCTION advise_partitioning_level(cubename IN VARCHAR2,
113: dimsources IN dbms_aw$_dimension_sources_t,

Line 113: dimsources IN dbms_aw$_dimension_sources_t,

109: dimsources IN dbms_aw$_dimension_sources_t,
110: advtable IN VARCHAR2 DEFAULT NULL)
111: RETURN VARCHAR2;
112: FUNCTION advise_partitioning_level(cubename IN VARCHAR2,
113: dimsources IN dbms_aw$_dimension_sources_t,
114: advtable IN VARCHAR2 DEFAULT NULL)
115: RETURN VARCHAR2;
116:
117: PROCEDURE aw_update(name IN VARCHAR2 DEFAULT NULL);