Home » Developer & Programmer » Warehouse Builder » ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP [message #173503] Mon, 22 May 2006 14:28 Go to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous message
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.
Previous Topic: Informatica - I would like to know something about the Session properties.
Next Topic: Advice me
Goto Forum:
  


Current Time: Wed Oct 01 07:29:12 CDT 2014

Total time taken to generate the page: 0.13135 seconds