Yet another partitioning question

From: Konstantinos Agouros <elwood_at_agouros.de>
Date: 23 Sep 2002 20:42:39 GMT
Message-ID: <1032813759.912595@rumba>

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 - 15:42:39 CDT