cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-1652: unable to extend temp segment by 699912 in tablespace ##PSAPTEMP

Former Member
0 Kudos

Dear Expert

I found this error ORA-1652: unable to extend temp segment by 699912 in tablespace ##PSAPTEMP. How can I fix this problem. Anyone help me...pls

best regards

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

If this is a UNIX system, the temp data files are NOT extended until the space is needed.

For example, if the temp data file is allocated to 10GBs, it will not use the space until it needs to. If the file system does not have enough free space when temp tries to extend, you get an error.

You may need to extend the size of your file system that stores the temp data files?

Former Member
0 Kudos

Hi,

We had the same error in our Production system.

That basically occured when there were a lot of Background jobs that were running.

As more than 5 jobs were running which were utisiling PSAPTEMP to the fullest invariably the jobs got cancelled with a dump and the error u have mentioned

Though we tried adding 3 datafiles the error kept repeating..

We finally added almost 20 GB to PSAPTEMP for those jobs to get completed.

Former Member
0 Kudos

Thank you for your answer.

former_member204746
Active Contributor
0 Kudos

it could have been a better idea to extend 1 datafile of PSAPTEMP instead:

brspace -c -u / -f dfalter

resize temp.data1 if you have enough disk space.

Former Member
0 Kudos

Hi,

Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace PSAPTEMP.

Reward points if helpful.

Regards

Ganesh