ORA-14763 when querying an interval partition
I am trying to test some features of an interval partitions. Here is my table
select * from smsg.test_table_part_interv;
ACCT_NBR SVC_MSG_ID CRTE_UID UPD_UID EXP_DT
---------------- ---------- -------- -------- -----------
1234123412341234 123456789 12341234 2010-aug-30
1234123412341235 123456789 12341234 2010-aug-30
1234123412341236 123456789 12341234 2010-aug-31
1234123412341237 123456789 12341234 2010-sep-10
It is partitioned by the EXP_DT column with daily intervals. Currently I have three intervals
I am testing the new syntax for select and getting ora-14763 eror
select * from smsg.test_table_part_interv partition for (to_date('2010-09-10', 'YYYY-MM-DD'))
*
ERROR at line 1:
ORA-14763: Unable to resolve FOR VALUES clause to a partition number