Home » Developer & Programmer » Reports & Discoverer » unable to extend temp segment by 128 in tablespace
unable to extend temp segment by 128 in tablespace [message #90135] Thu, 04 November 2004 02:30 Go to next message
Manyanye Amos
Messages: 18
Registered: October 2004
Location: Zimbabwe
Junior Member
I am having this message in trying to run a report

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
==> select d.entity_id, e.mpno, e.surname||' 'e.first_name ename, loan_ref_no, l.trans_date,d.amount, payee_name

what could be the problem and what am I supposed to do?

Report message to a moderator

Re: unable to extend temp segment by 128 in tablespace [message #90136 is a reply to message #90135] Thu, 04 November 2004 02:50 Go to previous message
Arvin AUDIT
Messages: 22
Registered: November 2004
Junior Member
Check your filesystem. One possible cause is that you have run out of space in the particular filesystem

Report message to a moderator

Previous Topic: generate a report in PCL format
Next Topic: dba
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 15:15:46 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.