U may also use ALTER TABLE REBUILD command
yours
- "Thapliyal, Deepak" <DThapliyal_at_ea.com>
> wrote:
>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-----
>Sent: Monday, September 25, 2000 11:04 AM
>To: oracledba_at_quickdoc.co.uk
>
>
>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)
>
>----- Original Message -----
>To: "LazyDBA (E-mail)" <oracledba_at_quickdoc.co.uk>
>Sent: Monday, September 25, 2000 12:25 PM
>
>
>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
>>
>
>--------
>If you're bored, then visit the list's website: http://www.lazydba.com
>(updated daily)
>to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
>to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>
>
>
>--------
>If you're bored, then visit the list's website: http://www.lazydba.com
>(updated daily)
>to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
>to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Thapliyal, Deepak
> INET: DThapliyal_at_ea.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Be someone_at_0racledba.com - get your free mail from Oriole Corporation
http://www.oriolecorp.com - Performance tools for Oracle DBAs
Received on Wed Sep 27 2000 - 06:00:37 CDT