newbie : Rollback tablespaces
From: Paul Smart <psmart_at_aus.sig.net>
Date: Tue, 28 Apr 1998 17:24:58 -0500
Message-ID: <6i5kud$p50$1_at_news13.ispnews.com>
Hi,
Date: Tue, 28 Apr 1998 17:24:58 -0500
Message-ID: <6i5kud$p50$1_at_news13.ispnews.com>
Hi,
I'm fairly new to Oracle and i'm having a problem with Rollback segments. I
don't really understand how Oracle uses this space. My rollback tablespace
increases in size to around 40Mb during some operations, as this is the max
i've set for the file subsequent accesses will error.
If i delete 800k of data the rollback increases by around 20Mb.
Is this normal? Is there any way of deleting records without using the
rollback segments? I've considered a script to just drop the table and
rebuild it as this shouldn't use the rollback, I'm guessing this is not
really the way to go..
please help!
Paul
Received on Wed Apr 29 1998 - 00:24:58 CEST