Re: Oracle free space

Someone wrote:

> Hi,
>
> 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!!!!!!
>
> Thank you

Why would you think they would be different?

Deleting data does not change the high-water mark on a table or index.

What you did seems like a hopelessly naive thing to do.

Why don't you state the business problem you are trying to solve and let someone suggest to you a solution.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)