Oracle DBMS_CUBE OLAP Fact Table Dimensions Build Validate XML Slave


	CODE Oracle Code Library


	JOBS Find Or Post Oracle Jobs


	FORUM Oracle Discussion & Chat

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

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

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