Re: Defrag for datafiles needed

From: Robert Fazio <rfazio_at_home.com.nospam>
Date: Sat, 11 Aug 2001 20:32:11 GMT
Message-ID: <fDgd7.94147$EP6.23093946@news1.rdc2.pa.home.com>

If the data isn't that great.

Alter table xxx move tablespace TheSameTS; That should clean it up also. You will need to rebuild the indexes though.

--
Robert Fazio
Senior Technical Analyst
dbabob_at_yahoo.com

"Konstantinos Agouros" <elwood_at_news.agouros.de> wrote in message
news:elwood.997558108_at_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 - 15:32:11 CDT