My Oracle Support Banner

ORA-14037 Creating a PARTITION TABLE with Composite RANGE PARTITION (Doc ID 220183.1)

Last updated on MARCH 10, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.3.0 to 9.2.0.1 [Release 8.0.3 to 9.2]
Information in this document applies to any platform.

Purpose

Explanation of why you get ORA-14037 from a CREATE TABLE ... command to create a RANGE PARTITION table with composite
partition keys.

The partition key consists of two CHAR() columns in this example.

Scope

This document is intended for any audience with at least moderate level of
SQL skill and understanding of a partition table.

The example only deals with the range partition but it can be extended to other types of partitions with
composite keys if that also fails with the same ORA-14037 from a CREATE TABLE command.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.