Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Space after a bulk Delete.
with 8i u can accomplish a live re-org and reset the HW of a table by using
the move clause --> alter table .. move
hth
deepAk
-----Original Message-----
From: Asif Hasan [mailto:animikh_at_bttb.net.bd]
Sent: Monday, September 25, 2000 11:04 AM
To: oracledba_at_quickdoc.co.uk
Subject: Re: Space after a bulk Delete.
Hi Suvash,
Everything is correct except that "space will not be used for future inserts or updates". If your pctused and pctfree parameters permits the space (holes) within a block can be filled by updates and inserts. Delete operation has nothing to do with high water mark. Currently export and import is the only way to work around the problem of block defragmentation.
Asif Hasan
(It is good to be alive, it is better to be young and it is the best to be
in love)
Hi DBA's
I have a point, which I want to know whether I am correct.
I have a table containing a million rows. If I delete the data in bulk from the table basing on a where condition. This means that High water mark is not reset and the space that was freed will still be part of the table, and will not be used for future inserts or updates. Also this creates lot of holes in the data blocks. And I understand that only export and import is the way to get away with the holes in the data blocks.
Kindly some body tell me whether I am correct.
thanks in advance
subhash
> ----------
> From: Anil Lancy Sequeira[SMTP:anils_at_mastekm.po.my]
> Sent: Sunday, September 24, 2000 8:12 PM
> To: LazyDBA (E-mail)
> Subject: Fetch Out of Sequence
>
> Dear DBA's
>
> Can any one suggest me why the problem is coming up, This procedure is
> run everyday without any errors for the last 3 years, but all of sudden my
> users have started encountering this problem, any solution
>
>
> Regards
>
> Anil Lancy Sequeira
>
![]() |
![]() |