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

an alternative to TSReorg which we use is SpaceManager from Quest Software http://www.quest.com/solutions/oracle.asp

for one of our production boxes with instances with 24x7x365 availability requirements, we use LiveReorg, also from Quest

"Frank an der Heiden" <fh_at_energotec.de> wrote in message news:97ie0d$7vk$1_at_oxygen.technet.net...
> 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 Fri Mar 02 2001 - 08:22:24 CST