ORA-14019: Problem With Sql From Doc About Using The Archival Utilities (19.4.3 Preparing the UPA Table for Archival and Purge) (Doc ID 1940513.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Identity Manager - Version 11.1.2.2.0 and later
Information in this document applies to any platform.

Goal

Steps described in
http://docs.oracle.com/cd/E27559_01/admin.1112/e27149/archival_utilities.htm#CJAJBAGC
19.4.3 Preparing the UPA Table for Archival and Purge

do not seem to work, creating the UPA_PART table fails with :

ERROR at line 17:
ORA-14019: partition bound element must be one of: string, datetime or interval
literal, number, or MAXVALUE
 

Solution

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