Alter table X move tablespace same_one_its_in_now may do the deed, though it
really needs to be a locally managed tablespace for the front part of the
datafile to get used with any high degree of confidence.
Regards
HJR
"Konstantinos Agouros" <elwood_at_news.agouros.de> wrote in message
news:elwood.998122830_at_news.agouros.de...
> Hi,
>
> I have the following problem (8.1.6.0.3 on Solaris7):
> Once in the night I import roughly 2-5mio entries using sqlldr
direct=true.
> After some work with the data I delete all of this data that's older than
> two days. So this one big table stays at about 10mio lines. I set my
datafile
> to autoextend and it keeps growing nevertheless. I guess the directpath
method
> simply appends to the end. So is there a way besides
exporting/dropping/import-
> ing all tables to keep the datafile tight?
>
> 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 18 2001 - 18:12:09 CDT
