Re: newbie : Rollback tablespaces

In article <6i5kud$p50$1_at_news13.ispnews.com>, Paul Smart <psmart_at_aus.sig.net> wrote:
>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

Yes. It can be quite strange at first. Oracle is keeping the before image until you commit your changes. The storage parameters of the rollback segment can make it bigger too.

>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..

There are two ways to go:

        Make your transactions smaller by committing more often.

        Use the SQL TRUNCATE TABLE to get rid of everything without rollback.

>
>please help!
>
>Paul
>
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry_at_eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the _at_#%*& DBA!