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

On Wed, 13 Oct 2004 11:15:10 +0800, "Yong Feei Shun \(UAC Berhad\)" <yong_feei_shun_at_uac.com.my> wrote:

>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
>
>

Exactly what do you mean by "delete some of the transactions"?

What do you check in OEM to tell you the number of rows?

What query did you issue in SQLPLus to determine the number of rows? Received on Wed Oct 13 2004 - 07:44:22 CDT