Re: Rollback segments errors

From: Pascal LAMBERT <pascal.lambert_at_sncf.fr>
Date: Mon, 23 Oct 2000 11:01:51 +0200
Message-ID: <8t0uo1$qkd$1@muguet.sncf.fr>

Hi,

if you got to delete the entire table use the SQL command TRUNCATE TABLE who do not use rollback segment.

Else, use a PL/SQL block who cycles DELETE like this :

BEGIN
    LOOP
        DELETE FROM TABLE WHERE ROWNUM < n; (where n = 1000, 2000 or more)

        EXIT WHEN SQL%NOTFOUND;
        COMMIT;

    END LOOP;
COMMIT;
END; Regards,

PASCAL <barko_at_attglobal.net> a écrit dans le message : 39f264fe_3_at_news1.prserv.net...
> I have been getting the following two errors when attempting to delete
 rows
> from a fairly large table.
>
> ORA-01623
> ORA-01562
>
> Both mention that the maximum number of extents (121) has been reached
> during rollback. To get around this I have to drop the table and reload
 it.
>
> Any suggestions?
>
> Chris
>
>
Received on Mon Oct 23 2000 - 04:01:51 CDT