CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [142 users online]    © 2010 psoug.org