Search the Reference Library pages:  

Oracle DBMS_CUBE

Version 11.1
 
General Information
Description ?
Source {ORACLE_HOME}/olap/admin/olapiboo.plb
First Available ?
Dependencies

DBMS_LOB

DBMS_OLAPI_LIB
Object Privileges Execute is granted to PUBLIC
 
BUILD

Create OLAP Cubes
dbms_cube.build(
script               IN VARCHAR2,
method               IN VARCHAR2       DEFAULT ?,
refresh_after_errors IN BOOLEAN        DEFAULT ?,
parallelism          IN BINARY_INTEGER DEFAULT ?,
atomic_refresh       IN BOOLEAN        DEFAULT ?,
automatic_order      IN BOOLEAN        DEFAULT ?,
add_dimensions       IN BOOLEAN        DEFAULT ?,
scheduler_job        IN VARCHAR2       DEFAULT ?);
TBD
 
BUILD_SLAVE

Th
dbms_cube.build_slave(
script             IN VARCHAR2,
partition_member   IN VARCHAR2, 
scheduler_job      IN VARCHAR2
master_build_id    IN BINARY_INTEGER,
slave_build_number IN BINARY_INTEGER);
TBD
 
IMPORT_XML

Th

Overload 1
dbms_cube.import_xml(in_xml IN CLOB);
TBD

Th

Overload 2
dbms_cube.import_xml(in_xml IN CLOB, out_xml IN OUT CLOB);
TBD

Th

Overload 3
dbms_cube.import_xml(dirname IN VARCHAR2, filename IN VARCHAR2);
TBD
 
VALIDATE_XML

Th
dbms_cube.validate_xml(in_xml IN CLOB);
TBD
 
Related Topics
DBMS_AW
DBMS_AW_STATS
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us    © 2003 - 2024 psoug.org
-----