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 -> Help: PL/SQL execution error

Help: PL/SQL execution error

From: Weidong Zhou <weidong.zhou_at_sabre.com>
Date: Mon, 07 May 2001 11:09:02 -0500
Message-ID: <3AF6C89E.E0EA5CFE@sabre.com>

Hi, all,
I have a PL/SQL procedure. It runs fine with one instance but have problems in another instance. The error is listed as follows: ORA-03232: unable to allocate an extent of 8 blocks from tablespace 2

The problem is that we do not have any tablespace name called 2. We know ROLLBACK tablespace use datafile 2 and the procedure do have a lot update operation. We add more space to ROLLBACK tablespace and still got the same error. Does anyone have any idea how to fix the problem. Thanks a lot.

Regards,

Weidong Zhou Received on Mon May 07 2001 - 11:09:02 CDT

Original text of this message

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