Home » RDBMS Server » Backup & Recovery » ORA-01652: unable to extend temp segment by 128 (Oracle 10g)
ORA-01652: unable to extend temp segment by 128 [message #590944] Wed, 24 July 2013 05:27 Go to next message
sss111ind
Messages: 480
Registered: April 2012
Location: India
Senior Member

Hi All,

I am getting this following error.After that we added more space to that.But still it is showing.
What might be the issue.


ORA-01652: unable to extend temp segment by 128  in tablespace TBSDESDBTMP
*Action:   Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
           files to the tablespace indicated.


It is showing to add datafile to that tablespace .How to achieve this.Please help.
Regards,
Nathan

[Updated on: Wed, 24 July 2013 05:27]

Report message to a moderator

Re: ORA-01652: unable to extend temp segment by 128 [message #590958 is a reply to message #590944] Wed, 24 July 2013 06:35 Go to previous messageGo to next message
Michel Cadot
Messages: 59127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you should read the documentation.
ALTER TABLESPACE for instance, isn't it obvious?

Regards
Michel
Re: ORA-01652: unable to extend temp segment by 128 [message #591865 is a reply to message #590958] Wed, 31 July 2013 22:12 Go to previous messageGo to next message
hitesh2711
Messages: 5
Registered: July 2013
Location: INDIA
Junior Member

Hello,

You can check for TEMP segments with this query:

select
srt.tablespace,
srt.segfile#,
srt.segblk#,
srt.blocks,
a.sid,
a.serial#,
a.username,
a.osuser,
a.status
from
see code depot for full scripts
v$session a,
v$sort_usage srt
where
a.saddr = srt.session_addr
order by
srt.tablespace, srt.segfile#, srt.segblk#,
srt.blocks;

You might have to do the following -

1. Increase size of the temp tablespace
2. Increase sort_area_size and/or pga_aggregate_target
Re: ORA-01652: unable to extend temp segment by 128 [message #591873 is a reply to message #591865] Thu, 01 August 2013 00:35 Go to previous messageGo to next message
Michel Cadot
Messages: 59127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
@hitesh2711,

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.
Use the "Preview Message" or "Preview Quick Reply" button to verify.

Regards
Michel
Re: ORA-01652: unable to extend temp segment by 128 [message #591891 is a reply to message #591873] Thu, 01 August 2013 03:39 Go to previous message
gazzag
Messages: 316
Registered: November 2010
Location: Bristol, UK
Senior Member
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3002.htm#i2093894
Previous Topic: question about data guard
Next Topic: Duplicate Database Unable to Read Backupset
Goto Forum:
  


Current Time: Thu Sep 18 11:26:31 CDT 2014

Total time taken to generate the page: 0.24698 seconds