Thank you for showing an example of interval partitioning with a number instead of a date. All of the other examples that I have seen are only with a date.
One thing I've noticed when using an interval partition with a number range, if the range spang is too great, the partition won't be created. For instance, if my first number is 100000000000000 and I have a "values less than" of 100000000100000, then new value will enter. Even if I put in a gradual increase up to 100199999999999, it works fine, but try and put in a number like 200000000000000 without gradually making it closer to that partition key, you get a basic error message saying there is no partition with that key number to attach itself to. Is this a bug?
- Post a complete test case we can reproduce and give us your Oracle version with 4 decimals like 10.2.0.1.
- Michel Cadot 16:26, 8 February 2011 (UTC)
I may have to put in a ticket with Oracle. We are on an Exadata Oracle 11g R2 box. I don't have acces to the version number at the moment. I will try to provide later.
I can send you screenshots if you provide an email address. I've tried to post here but msg looses formatting. Michael Mayhew
- I can't execute a screen shot; I want code in text I can copy and paste in SQL*Plus.
- Michel Cadot 19:05, 8 February 2011 (UTC)