DataPump Fails With Error ORA-1867 When DBMS_METADATA.GET_DDL "TO MONTH" Changed To "TOMONTH" (Doc ID 1457514.1)

Last updated on JUNE 05, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and later
Oracle Database - Standard Edition - Version 11.2.0.2 and later
PL/SQL - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

DataPump or DBMS_METADATA.GET_DDL returns "ORA-1867 the interval is invalid" when To Month Interval partition is used

Example:

PARTITION BY RANGE ("TEST_DATESTAMP") INTERVAL (INTERVAL'+0-1'YEAR(1)TO MONTH)

Cause

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 hundreds of Community platforms