Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: rollback/commit question

Re: rollback/commit question

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 02 Feb 2000 01:35:19 GMT
Message-ID: <38978936.108823199@news.eagles.bbs.net.au>


Hi Jay,

The problem is that you are committing too frequently. There is a tip on why this error occurs and how to avoid it on my web site (1st URL below).

Regards,
Steve Adams

http://www.ixora.com.au/

http://www.oreilly.com/catalog/orinternals/

http://www.christianity.net.au/



On Wed, 02 Feb 2000 00:38:58 GMT, jxs_at_walaw.com (Jay Scheiner) wrote:

>This is from the perspective of a farily new Oracle user, doing learn
>as you go.
>I have created a database that we will be using for data warehousing.
>I have successfully import about 6 weeks worth of data into a single
>table (about 75-100K records/day). I then created a new column and
>wanted to populate that column based on a current column.
>
>I have a PL/sql procedure something like
>(cursor defined)
>loop
> get cursor rec
> update cursor.column = value
> cnt:=cnt+1;
> if cnt > 500 then
> commit;
> cnt :=0;
> end if
>end loop
>commit;
>
>I tried running it for the whole table, go a rollback seg size error.
>So now I am running it for 1 days records at a time, and sometimes it
>goes through, sometimes I get
>
>snapshot too old, rollback seq # .... w/name RB22 too small
>
>I know that I will need to expand rollbacks, set up tablespaces, etc.
>BUT after all this, my question is why doesn't this commit every 500
>updates keep the rollback from getting too large?
>
>Thanks in advance.
Received on Tue Feb 01 2000 - 19:35:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US