ORA-01652

[cyno]

Hi
Iam tring to run a script which will update 5 tables(we have like 200000 records in each table) and inserts into different table after the updates.Iam getting the following error when i tried to execute the script.We added half gig to temp tablespace but still getting the same problem.Does anyone encounterd this?

ORA-01652: unable to extend temp segment by 1280 in tablespace TEMP

cyno

 

[hoinz]

from Oracle documentation;

ORA-01652: unable to extend temp segment by string in tablespace string
Cause: Failed to allocate an extent for temp segment in tablespace.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

 

[aryeh1010]

You might check the inserts and update statements. If there are things like union, distinct, order by in them, they are causing sorting.

The problem might be one of tuning, not how much space you have in the temp tablespace.

What I've done in similar situations is to split up the updates into simpler chunks. That has reduced the amount of sort activity and kept things running smoothly.

Aryeh Keefe