HELP: 0RA-01631: max # extents (505) reached in table PLNDAD (7.1.6/SCO5)

From: Mitech <mitech_at_mitech-retail.com>
Date: Tue, 09 Jun 1998 21:44:00 GMT
Message-ID: <357DAC61.8003A840@mitech-retail.com>

Hi all,

I got the error 0RA-01631: max # extents (505) reached when trying to update PLNDAD table.

Oracle version 7.1.6 on SCO 5.0.4 with the patch for installation on SCO 5.

DB_BLOCK_SIZE = 8K                 (will give MAXEXTENTS = 505)

TABLESPACE parameters:

Create tablespace DATA
datafile '/dbf/DATA.dbf' size 1000M
default storage (

      initial 512K
      next 512k
      pctincrease 0

);

Table Parameters:

Create table PLNDAD
( CONTRAINT PK_PLNDAD PRIMARY KEY (SEQ_NUM,DATA_SECTION,DATA_BLOCK),

              SEQ_NUM                                        NUMBER(10)

CONSTRAINT fk_seq_num

REFERENCES plndat(seq_num)

ON DELETE CASCADE,

              COMPRESSD                                   NUMBER(1),
              DATA_SECTION                              NUMBER(10) NOT
NULL,
              DATA_BOCK                                     NUMBER(3)
NOT NULL,
              DATTA                                              LONG

RAW
)

TABLESPACE DATA
STORAGE ,(INITIAL 30M NEXT 10M) Insert records in the table PLNDAD in tablespace DATA with statement:

EXEC SQL INSERT INTO PLNDAD
(SEQ_NUM,COMPRESSED,DATA_SECTION,DATA_BLOCK,DATTA) VALUES
         (:dat_seq_num, 0 , 256, 1, :tmp_datta);

The Oracle Error messages says:

ORA-01631 : Cause: the maximum amount of space allowed for saving undo entries has been reached for the named table (PLNDAD)

Action: Increase the value of either the MAXEXTENTS or PCINCREASE initialization parameters

but I think the tablespace DATA and PLNDAD will take the value of 505 for MAXEXTENTS by default :-(

I wonder someone can help me get out this problem. I'm really stuck in that.

Thanks in advance for any help.

Huy Vu Received on Tue Jun 09 1998 - 16:44:00 CDT