OraFAQ Forum: Data Integration » ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Home » Developer & Programmer » Data Integration » ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

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

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP [message #173503]

Mon, 22 May 2006 14:28

aloorip
Messages: 1
Registered: May 2006

Junior Member

Hi All,

I am getting the below errors while executing a mapping which loads the data to a fact table.

if anyone came across the similar issue, please let me know the solution.

ORA-12801: error signaled in parallel query server P014
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Thanks,
Aloori

Report message to a moderator

Re: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP [message #174086 is a reply to message #173503]

Thu, 25 May 2006 17:06

ottkaresz
Messages: 12
Registered: March 2006
Location: Hungary

Junior Member

Hi

This is not an OWB error, this is an SQL error.
Check the executaion plan of the query, and analyze the tables.
Maybe you should increase the temp tablespace in the database.
The problem is that the query gets to much data. Try to filter or increase the data of the query.

Ott Karesz
http://www.trendo-kft.hu

Report message to a moderator

Re: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP [message #176226 is a reply to message #173503]

Wed, 07 June 2006 07:38

Ferrarist
Messages: 29
Registered: March 2006
Location: Netherlands - Den Haag

Junior Member

Contact your DBA and have the TEMP tablespace extended. It's exactly what Ott Karesz says. A little work around could be splitting up the mapping in smaller parts by flushing smaller intermediate results to a temporary table.

Report message to a moderator

Previous Topic:	Informatica - I would like to know something about the Session properties.
Next Topic:	Advice me

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 19:47:10 CST 2024