| ORA-01652: unable to extend temp segment by 128 [message #590944] |
Wed, 24 July 2013 05:27  |
 |
sss111ind
Messages: 636
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 #591865 is a reply to message #590958] |
Wed, 31 July 2013 22:12  |
 |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
