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 220.127.116.11 - 18.104.22.168, Oracle Data Miner uses object-relational storage.
Approximately 200MB - 700MB XML DB object-relational storage is required.
With Oracle Database 22.214.171.124 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;