Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Defrag for datafiles needed

Defrag for datafiles needed

From: Konstantinos Agouros <elwood_at_news.agouros.de>
Date: 11 Aug 2001 21:31:28 +0200
Message-ID: <elwood.997558108@news.agouros.de>

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 Sat Aug 11 2001 - 14:31:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US