Generate statistics for the objects. Then DBA_TABLES and DBA_INDEXES will
have accurate data. Note that if you are using rule-based optiomization
then you will want to delete the statistics afterwards. The existence of
statistics under 7.3 will trigger the cost based optimizer.
Robert Eisenhardt wrote in message <6pdgv4$ecr$1_at_news02.btx.dtag.de>...
>Hello,
>
>I have to reorganize a tablespace. In this tablespace a lot of records
>were deleted. So how can I get the real free space in this tablespace
>to reduce the size when reorganizing it.
>
>Thanks a lot
>
>Robert Eisenhardt
>---
>email: Robert.Eisenhardt_at_t-online.de
Received on Tue Jul 28 1998 - 13:37:36 CDT
