OraFAQ Forum: Server Administration » ORA-04à30 (split from Table space with different block size inside same database)

Home » RDBMS Server » Server Administration » ORA-04à30 (split from Table space with different block size inside same database)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-04à30 (split from Table space with different block size inside same database) [message #532998]

Sat, 26 November 2011 00:50

truptijadhav
Messages: 1
Registered: November 2011
Location: Mumbai

Junior Member

i writen this code i m facing ORA-04030: out of process memory when trying to allocate 16408 bytes error pls give me solution

/* Formatted on 2011/11/26 11:52 (Formatter Plus v4.8. Cool

*/
DECLARE
row_id varchar2(50);
v_batch_id temp.batch_id%TYPE;
v_slab_id temp.slab_id%TYPE;
flag NUMBER (2);
num varchar2(50) := &row_id;

CURSOR c1
IS
SELECT batch_id, slab_id
FROM temp;
BEGIN
OPEN c1;

LOOP
FETCH c1
INTO v_batch_id, v_slab_id;

DBMS_OUTPUT.PUT_LINE (v_batch_id || ' ' || v_slab_id || flag);
flag := 1;
EXIT WHEN c1%ROWCOUNT > (num - 1);
END LOOP;

CLOSE c1;
END;

Attachment: trypagefinal.sql
(Size: 0.54KB, Downloaded 1258 times)

Report message to a moderator

Re: Table space with different block size inside same database [message #532999 is a reply to message #532998]

Sat, 26 November 2011 00:53

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do NOT hijack a topic with an unrelated question.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decim

ORA-04030: out of process memory when trying to allocate %s bytes (%s,%s)
 *Cause:  Operating system process private memory has been exhausted

Increase allowed memory to oracle OS account.

Regards
Michel

Report message to a moderator

Previous Topic:	Is tablespace size required to increase
Next Topic:	Writting control file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 17:50:55 CST 2025