Re: Yet another partitioning question

You have unbalanced parenthesis there. Take one off from the end and it should work for you.

Richard.

Konstantinos Agouros wrote:
>
> Hi,
>
> after I finally got my development installation done I managed to do a create
> table with a partition. Partitions are only useful for me when I can add some
> afterwards so i did the following two things:
>
> SVRMGR> create table partitiontest (id number(10), datum date) partition by
> range (datum) (partition P18092002 values less than (to_date('18-SEP-2002',
> 'DD-MON-YYYY')));
> Statement processed.
>
> SVRMGR> alter table partitiontest add partition P19092002 values less than (to_date('19-sep-2002','DD-MON-YYYY')));
> alter table partitiontest add partition P19092002 values less than (to_date('19-sep-2002','DD-MON-YYYY')))
> *
> ORA-14048: a partition maintenance operation may not be combined with other operations
>
> What am I doing in wrong in adding a partition. I looked at the alter table
> description on technet and I understood it this way.
>
> Konstantin
> --
> Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood_at_agouros.de
> Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
> ----------------------------------------------------------------------------
> "Captain, this ship will not survive the forming of the cosmos." B'Elana Torres
Received on Mon Sep 23 2002 - 18:48:44 CDT