Re: Determining the size of the database after deleting some of the transactions

"Yong Feei Shun \(UAC Berhad\)" <yong_feei_shun_at_uac.com.my> wrote in message news:<416c9dc0_1_at_news.tm.net.my>...
> Dear all
>
> I have a question here hopy you guys can help me.
> I tried to delete some of the transactions, then export the whole
> db out, and then import it back and check on the size. but I noticed that
> when I check it from the oracle enterprise manager, the number of rows still
> the same as before deleting, but when I check using the sqlplus, apparently,
> the number of rows decreased. Why? and what should i do if i really want to
> know the exact size of the database after deleting?
>
> Please help. Thank you
>
>
> Regards
> Feei Shun

You need to update the statistics on the tables at the very least. EM most likely gets the row count from the dba_tables view, this view does not reflect an accurate count unless the statistics is up to date.

Louis Frolio Received on Wed Oct 13 2004 - 08:07:39 CDT