Re: Rollback Segments
Date: Wed, 1 Dec 1993 18:38:36 GMT
Message-ID: <CHDD4C.Gqt_at_mizar.com>
cohen_at_pni.sra.com (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