Partitioning

Oracle Partitioning Option

The Partitioning Option is a separately licensed Oracle Database Enterprise Edition option.

Check Feature Usage

SET LINESIZE 200
SELECT u1.name, u1.detected_usages
  FROM dba_feature_usage_statistics u1
 WHERE u1.version = (SELECT MAX(u2.version)
                       FROM dba_feature_usage_statistics u2
                      WHERE u2.name = u1.name
                        AND u1.name LIKE 'Part%') 
 ORDER BY u1.name;

If the detected usages for "Partitioning (user)" is non-zero, then you need a Partitioning option license.

Partitioning is different from most other options because it is split into a user and system component. The system component is present if partitioning has been part of the database at any time in the past. Fully removing it is not possible afterwards. However, the system partitioning component is not relevant from the licensing point of view - only the use of the user partitioning component is relevant. (1468698.1)

Oracle Partitioning Features

  • Table Partitions and Subpartitions
  • Global and Local Index Partitions and Subpartitions
  • Sharded Queues
  • Zone Maps (Available only on EE-Exa and ExaCS – requires Exadata or Supercluster)

Bibliography


https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dblic/Licensing-Information.html How To Disable Partitioning And Impact On Licensing (Doc ID 1468698.1)