on 07-12-2007 10:01 AM
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Thank you for your answer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace PSAPTEMP.
Reward points if helpful.
Regards
Ganesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.