Re: How to release unused HD-Memory of datafiles?

hi sybrand,

thanx for the help.
what is TSReorg for a tool and where can I get it?

so long
frank

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:t9nfqu61bj383c_at_beta-news.demon.nl...
> A delete doesn't adjust the high watermark,
> a deallocate unused doesn't reorganize your table, it deallocates extents
> not longer in use, so this will leave 'holes' in your tablespace. The only
> way to reset the hwm is using truncate and/or export /import your data or
> use a tool like TSReorg.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
> "Frank an der Heiden" <fh_at_energotec.de> wrote in message
> news:97gbut$cl1$1_at_oxygen.technet.net...
> > hi folks,
> >
> > I have a problem concerning the unused memory of my datafiles.
> > Four times a year, we are exporting the contents of a table to a CD
> > and delete these exported rows of the table in the database.
> >
> > I try to decrease the highwatermark by using
> > ALTER TABLE <tablename> DEALLOCATE UNUSED;
> >
> > This statement is processed correctly.
> > Afterwards, I try to change the size of the datafile, which contains
> > <tablename> by using the expression
> >
> > ALTER DATABASE DATAFILE <datafile> RESIZE 200M;
> >
> > This does not work. The system all time tells me that the specified
> > datafile requires more memory, than the size I whish to reduce it.
> >
> > One strange thing is, also if I delete ALL rows, the same behavier.
> > If I use the truncate command, before resizing the datafile, everything
> > works fine.
> > Where is the difference between deleting all rows and reducing the
> > highwatermark
> > and truncating the table?
> >
> > Btw: We are using BLOB columns in all our tables, maybe this could be
 the
> > reason?!?
> >
> > Thanx a lot in advance
> > --
> > MfG / Best Regards
> >
> > Frank an der Heiden
> > ESA - Energotec Systeme und Automation GmbH
> > Tel: +49 (0)211 91440-19
> > Fax:+49 (0)211 669343
> > email: fh_at_energotec.de
> > "I came, saw and installed everything new!"
> >
> >
> >
> >
>
>
Received on Wed Feb 28 2001 - 02:48:33 CST