Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Defrag for datafiles needed
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 TorresReceived on Sat Aug 11 2001 - 14:31:28 CDT