Re: Mass Deletions From Tables

On Wed, 07 Aug 2002 18:34:14 GMT, "Stephen Ferracioli" <sferraci_at_pioneer-usa.com> wrote:

>My company is using SAP Business Warehouse (BW). BW allows us modify update rules and to re-load
>existing data transparent to the user. When the loads are complete, the previous packets of
>data are deleted. My question is this:
>
>When a table approx 500Mb in size grows by another 500Mb and then the first 500 Mb is deleted,
>will Oracle reclaim the space that is now no longer in use or do I need to reorganize (i.e.
>export/import) the table to get that space back?
>
>Thanks
>
>Stephen Ferracioli
>Database Administrator
>Pioneer Electronics
>

Depends whether the blocks from which data was deleted fall below pctused. You are deleting the *logically* first 500 Mb, do you? You can't guarantee they are *physically* the first 500 Mb.

Usually you are left with holes everywhere and the only solution is to reorganise.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Aug 07 2002 - 16:16:04 CDT