deleting lobs in 8i

[bardley]

Hey all,

I am not even remotely a DBA (this is a good thing, trust me), but I do end up "helping out" every once in a while.

My understanding of redo logs tells me that when you perform any insert/update/delete, it keeps a log of whatever data is inserted/updated/deleted so you can restore from it later. Naturally, these logs take up valuable disk space, especially for busy tables.

My question is - we have a lot of reports stored in .pdf format as BLOBs in a certain table. If I set up a procedure to remove the old ones on a weekly basis, will that blob data (potentially 100's of Mb) be written into log files as well?

Thanks,
brad

Brad Gunsalus
bardley90@hotmail.com

 

[dbadmin]

Hi,

Yes, it gets written to the redo log files.

dbadmin.