Re: Rollback Segments

From: Lanfeng Li <>
Date: Wed, 1 Dec 1993 18:38:36 GMT
Message-ID: <> (Janine Cohen) writes:

>hello, I am new to using ORACLE V7.0.15 and I have a question about rollback
>segments. I know that each transaction can only write to one rollback
>segment. I have a transaction that delete about 200 megs of information.
>I was wondering if there is any way to get around having a 200 meg rollback
>segment allocated (we don't want to waste so much space if we can help it).

>Specifically - is it possible to commit portions of a large delete so that
>that part of the rollback segment info could become inactive and thus reuse
>the existing extents?

 Yes. At least I did it using ORACLE V6.0. You can write a PL/SQL block with  a loop to count how many records you have deleted, say every 1000 records  you issue COMMIT and start over counting again.

>I would appreciate any information that you could give me.

>Thanks, Jeanine Cohen
> SRA Corporation
> Fairfax, Virginia
Received on Wed Dec 01 1993 - 19:38:36 CET

Original text of this message