Question about partitioning...

Hi,

I have the following problem: I have a table into which every day a few million lines are added using sqlldr in direct mode. I do some work on the data and two days later it is deleted. Currently this is done with delete from table where date < the_day_before_yesterday.
This of course is terribly slow (Sun E450 running Oracle 8.1.6). So the answer for this would be to partition the table by day and create a new partition for each day and then instead of delete from drop partition. But: Since sqlldr in directmode is very fast but also ignores some things (like free blocks in the middle of a datafile) will the partitions be honored? When do I have to create new partitions before or after the sqlldr-command?

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