Home » RDBMS Server » Server Administration » ORA-04à30 (split from Table space with different block size inside same database)
ORA-04à30 (split from Table space with different block size inside same database) [message #532998] Sat, 26 November 2011 00:50 Go to next message
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;
Re: Table space with different block size inside same database [message #532999 is a reply to message #532998] Sat, 26 November 2011 00:53 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Is tablespace size required to increase
Next Topic: Writting control file
Goto Forum:
  


Current Time: Thu Mar 28 19:27:55 CDT 2024