5738 Partition Violation Error occurs while am trying to insert data

Database
Enthusiast

5738 Partition Violation Error occurs while am trying to insert data

Hi All, Please help me to fix the partition violation error.

When am tring to load datas into my target table, am getting 5728 partition violation error.

Partition range mentioned below,

PRIMARY INDEX ( CUST_ID )

PARTITION BY ( RANGE_N(ENDT  BETWEEN DATE '1991-01-01' AND DATE '2004-12-31',

DATE '2005-01-01' AND '2010-12-31' EACH INTERVAL '1' MONTH ,

DATE '2011-01-01' AND DATE '2018-12-31' EACH INTERVAL '1' DAY ,

 NO RANGE)

Thanks

Tags (1)
1 REPLY
Senior Apprentice

Re: 5738 Partition Violation Error occurs while am trying to insert data

There's probably a NULL in your data and there's no UNKNOWN partition.

Dieter