Rollback Segments
From: Janine Cohen <cohen_at_pni.sra.com>
Date: 24 Nov 1993 21:06:06 GMT
Message-ID: <2d0ibu$nai_at_snoopy.sra.com>
Date: 24 Nov 1993 21:06:06 GMT
Message-ID: <2d0ibu$nai_at_snoopy.sra.com>
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?