Re: Defrag for datafiles needed

By definition direct=true is loading above the High Water Mark of a table. So it will always extend that table.

The only way to lower that HWM is to truncate that table.

Martin

Konstantinos Agouros wrote:
>
> Hi,
>
> I have the following problem (Oracle 8.1.6.0.3 on Solaris):
> I have an application that once a night import up to 5 million entries
> using sqlldr with option direct=true. I set the file to autoextend=true.
> The data is reduced and afterwards deleted (using delete from where date < ...
> not truncate). The datafile keeps growing as direct=true seems to ignore free
> blocks and appends for performance reasons. Is there a way besides exporting,
> dropping and importing the whole database to keep the datafiles to a minimum?
>
> 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 sustain the forming of the cosmos." B'Elana Torres
Received on Thu Aug 23 2001 - 11:50:08 CDT