Home > Data Miner 4.0 > Oracle Data Mining Applicat... > Install Prerequisites and O... > Installation Strategy > Install Oracle Database > XML DB Requirements for Dat...
Data Miner uses Oracle XML DB to store workflow XML documents. The workflow documents are stored as XMLType data types.
XMLType is an abstract data type that provides these storage models:
Object-relational storage – XMLType data is stored as a set of objects.
Binary XML storage – XMLType data is stored in a post-parse, binary format specifically designed for XML data.
Storage used by Oracle Data Miner depends on the version of Oracle Database to which you connect:
Object-relational storage is used with Oracle Database 11g Release 2 (11.2.0.1), Oracle Database 11g Release 2 (11.2.0.2,) and Oracle Database 11g Release 2 (11.2.0.3).
Binary XML storage is used with Oracle Database 11g Release 2 (11.2.0.4) and later, including Oracle Database 12c.
Binary storage has the following configuration requirements:
ODMRSYS permanent tablespace must be an Oracle Automatic Storage Management (Oracle ASM) tablespace.
Here is an example of how to create an Oracle ASM 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;
Database compatibility level must be 11.2.0.0 or later.
Check database compatibility level with
select VALUE from database_compatible_level;