Is space released after deletes?
From: Yuri Ludevig <WBRD34A_at_prodigy.com>
Date: 1996/09/10
Message-ID: <513u9b$1dje_at_useneta1.news.prodigy.com>#1/1
Date: 1996/09/10
Message-ID: <513u9b$1dje_at_useneta1.news.prodigy.com>#1/1
I can't get a definite answer if Oracle reuses space after deletes. I ran
analyze before and after deletes (I deleted all rows form the table) and
statistics didn't seem to change (number of empty blocks, extents, bytes
used, etc). Anybody out there knows for sure if you have to do
export/import or Oracle takes care of all the holes?
Thanks,
Yuri in NY
Received on Tue Sep 10 1996 - 00:00:00 CEST