Thanks for your reply. I did this is becoz I need to know how much space i
need to allocate for the db after the deletion.
I already deleted some of the data from the tables, then export, then import
again to check on the reduced size of the db, but still getting the same
result.
What should i do now? Please help!!!!
"HansF" <news.hans_at_telus.net> wrote in message
news:2k%dd.32195$z96.4662_at_clgrps12...
> Someone wrote:
>
> >
> > I am having a problem here, hope you all could help me out.
> > I intend to check what are the sizes of my database taken up
> > after
> > the deletion of some of the data, so this is what I did.
> > Frist, I deleted the data from my database, then I used the
> > analyzer to ensure the rows of the tables are actually reduced. Then, I
> > did a export again, and then re-imported the database back to my PC.
from
> > there I wish to see the result of the before and after deletion effect.
> > But, it failed. The result shows me both the after and before deletion
is
> > the same. What are the steps that I had done wrongly? The below is the
> > script for analyzing the free spaces available. The output of the before
> > and after for tablespace ftable is the same. I have no idea why the
system
> > still show me the same result after the deletion. Please help!!!!!!
> >
>
> Can you explain WHY this is a problem for you? (Understanding your reason
> will help in the way we respond!)
>
> The reason I ask - many people have a mistaken impression that when they
> delete from tables, the datafile for the tablespace should reduce as well.
> (I get the feeling from your select statements that you might expect
that.)
>
> In other cases, people forget that the space will be re-used as necessary
if
> the table is filled again. Thus, having space pre-allocated as a result
of
> delete is not necessarily a bad thing.
>
> There are several possible ways of 'recovering' free space. Some of those
> ways depend on the version of the database, and possibly the operating
> system - it would help to get that information.
>
> Between the export and import, did you 'clean up' the tables (delete,
> truncate or drop)? Or was the delete only before the export? Are you
> aware of the 'High Water Mark' concept?
>
> /Hans
Received on Thu Oct 21 2004 - 23:00:12 CDT
