Table partitioning in ORACLE...

From: cutie <ShuchiTandon_at_gmail.com>
Date: 19 Dec 2005 05:53:10 -0800
Message-ID: <1135000390.525641.262480_at_g44g2000cwa.googlegroups.com>

Hi all,
  i have a task of creating a procedure for partitioning a row of already partitioned table as i.e.
procedure that creates new table partitions should do: 1)Check if partition F_100000000 is empty; if no raise exception. (certainly partition name F_100000000 should not be hard-coded) 2)Split partition F_100000000 x times (x -number of new partitions to create from input).
Upper limits for new partitions must be calculated according to input parameter (partition step) and largest (less than F_100000000)existing partition limit.

[Quoted] i cant understand...first of all how can i check if the partition is EMPTY OR NOT????secondly....if its empty then is it write to just write

alter table sh
 --split highest partion
 split partition F_100000000
 at (xx) --how can i define this xx exactly???????????????  INTO (

       --lower part first !
        PARTITION SFBR_xx, -- (new part limit)
        --
        PARTITION F_100000000
        );

 I hope someone wil try to explain me as soon as possible, regards. Received on Mon Dec 19 2005 - 14:53:10 CET