Deleting Table Logs

[Former Member]

I have to delete the Table Logs from the table DBTABLOG. I tried to schedule the job for it. Since its of a size 250GB, I am getting the rollback errors in the job.

Then I decided to take out all the logged tables and delete it in parts. In that process I was successful in deleting the old entries.

But my problem is even after deleting the entries(1 million entries roughly) from the table there is no change in the size of the table. Still its showing 250 GB.

I want to know how much size of the data I deleted.

Thanks

~Kasi

[JPReyes]

Unfortunately you won't recover the space until a reorganization is done.

Regards

Juan

[Former Member]

Hi Juan,

May be I didnt explain it fully. I dont want that space physically...

But I want the DBTABLOG table size to shown less from the original 250 GB. Or at least I want to know how much size of the data I deleted from the table.

Thanks

~Kasi

[JPReyes]

you can calculate the amount of records x the lenght of the record and you'll get a good aprox.

Regards

Juan

[Former Member]

I guess you confused table log and database log. If you want to cut database log, please backup database log, then shrink the database.

Edited by: Junyan He on Aug 28, 2009 11:27 AM