"Konstantinos Agouros" <elwood_at_agouros.de> wrote in message
news:1029170703.439587_at_rumba...
> 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
I'd recommend 'Practical Oracle 8i: Building Efficient Databases' by
Jonathan Lewis.
Regards,
Paul
Received on Mon Aug 12 2002 - 13:52:54 CDT
