Re: pl/sql problem

From: Howard Lee Harkness <harkness_at_airmail.net>
Date: Tue, 13 Jul 1999 19:03:55 GMT
Message-ID: <17CF2496A5D8442C.27FE8048A66BD250.EF365B3B0EB2E844@lp.airnews.net>

On Mon, 12 Jul 1999 11:40:53 -0700, "Mark Wagner" <mark_at_cybertrails.com> wrote:

>Im trying to run this pl/sql script and getting the following error......
>
>SQL> @test2
>DECLARE
>*
>ERROR at line 1:
>ORA-01562: failed to extend rollback segment number 2
>ORA-01650: unable to extend rollback segment R01 by 64 in tablespace RBS
>ORA-06512: at line 21

Try something like:

            loopcounter := loopcounter + 1;
            IF MOD(loopcounter, 10000) = 0 THEN COMMIT; END IF;

in your loop. The 10000 is an arbitrary number. I have to do this sort of thing because I am building some very large tables.

hlh_NOSPAM_at_excite.com is a valid, unmunged address! It is also so full of spam(!) that I don't read it. Received on Tue Jul 13 1999 - 14:03:55 CDT