Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error while adding new partiotion to a range partitioned table
"aspirant" <asprs_at_yandex.ru> a écrit dans le message de
news:1a4eff9f.0408310126.1c3a0f11_at_posting.google.com...
> key columns from user_part_key_columns:
> 44 SUMMARY TABLE SERVICE_DATE 2
> 43 SUMMARY TABLE SERVCLASS_CODE 1
>
> existing partitions:
> name: test
> less: 'PHONE', TO_DATE(' 2004-09-30 00:00:00', 'SYYYY-MM-DD
> HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')
> ...
>
> so the problem is i cannot add new partition:
> name: test2
> less: 'DIALUP', TO_DATE(' 2004-10-30 00:00:00', 'SYYYY-MM-DD
> HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')
> ...
>
> it seems i cannot add new partition even when my first key < that the
> previous. Just for example D<P.. so that's it.. am i right or ...?
You cannot add the new partition as the values it will contain are already covered by an old one. The only thong you can do is to split the old one at the new value.
And maybe your partition schema in not the good one. I think of something like partition by date subpartition by class (range+list) Or if you want to keep one level adding a ('class',maxvalue) partition for each class that you can split each month avoiding to get some dialup info in phone class...
-- Regards Michel CadotReceived on Tue Aug 31 2004 - 05:13:03 CDT