Adding a PARTITION gives Internal ERROR : Please donot submit the last request PARTITION BY RANGE_N(

Database
rs2
Enthusiast

Adding a PARTITION gives Internal ERROR : Please donot submit the last request PARTITION BY RANGE_N(

When I add partition to the table : PARTITION BY RANGE_N(ORDR_OPN_DT between ADD_MONTHS((DATE - EXTRACT(DAY FROM DATE)+1), -46) and Add_Months (current_date, 23) EACH INTERVAL '1' MONTH ) ;  

 

 

It gives an internal error : Please donot submit the last request. 

Any thoughts . When I remove the partition from the table, a simle query ike select * where ordr opn dt = '2016-11-16'  runs fine. But with the partition a date filter gives out an error. 

1 REPLY
Enthusiast

Re: Adding a PARTITION gives Internal ERROR : Please donot submit the last request PARTITION BY RANG

Remove the analytical functions from the partition and give exact dates....