Recover table size.

[mzahid]

Hi,

I create a table TABLE1 and populated this table with 75000 rows. Then I ran query to find out the size of my table.
select bytes from dba_segments;
bytes returned were 3.4MB then I added 75000 rows in the table (table1) again which increased my table size to 5.4MB.
After commiting TABLE1 I deleted about 70000 rows from
TABLE1. Now the problem is when I run query :
select bytes from dba_segments where segment_name='TABLE1'; I get 5.4MB bytes.

I want to see the original size of the table after deleting 70000 rows. I have tried to truncate my table and no luck. Can someone help me with this problem? And, how can I determine how many extents are being used by TABLE1 on tablespace oracle817 or segment.

I am using Oracle 817 on windows2000 machine.

Thanks in advance.

[dknight]

You can find the number of extents with DBA_SEGMENTS.

I don`t have Oracle on this computer, so this is a general answer.

Try to count the number of extents and group by the segment_name using the DBA_SEGMENTS table.

Good luck.

[pando]

Originally posted by mzahid

Now the problem is when I run query :
select bytes from dba_segments where segment_name='TABLE1'; I get 5.4MB bytes.

that is expected behaviour, not a problem. Deletes do not free space

if youw ant to see real data you have to check dba_tables providing you have analyzed table previously