delete rows with LONG RAW

From: Vadim Grepan <kezal_at_mail.ru>
Date: Wed, 29 Sep 1999 17:58:46 +0400
Message-ID: <7st646$suf$1@storm.comstar.ru>

Hello All!

   I need to delete some rows from table with LONG RAW field (each field keeps

   about 10Mb). I've tried somthing like DELETE tbl_data WHERE id=12343    but 've got error message:

        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   Should I extend my rollback segments by hand (they are small enough) or there is
  better manner?

Rgds, Vadim Grepan

---

kezal_at_mail.ru
2:5020/653_at_fidonet.org Received on Wed Sep 29 1999 - 08:58:46 CDT