The storage format used by Oracle Data Miner depends on the version of the database:
The Oracle Database versions and the corresponding storage format used by Oracle Data Miner are:
With Oracle Database 11.2.0.1 - 11.2.0.3, Oracle Data Miner uses object-relational storage.
Approximately 200MB - 700MB XML DB object-relational storage is required.
With Oracle Database 11.2.0.4 and later, Oracle Data Miner uses binary XML storage.
With binary storage, a tablespace allocation of 200MB can store approximately 1000 moderately complex workflows (about 35 nodes).
To use binary storage, ODMRSYS must be created in a tablespace managed with Automatic Segment Space Management (ASSM).
The following statement shows how to create an Oracle ASSM tablespace:
CREATE TABLESPACE DMUSER_AUTO DATAFILE 'DMUSER_AUTO.dat' size 20m
autoextend on next 32m maxsize UNLIMITED extent management local
AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;