Database DataWarehousing (MOSC)

MOSC Banner

ORA-14763 when querying an interval partition

edited Aug 31, 2010 4:00AM in Database DataWarehousing (MOSC) 3 commentsAnswered ✓
Hello:

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center