cancel
Showing results for 
Search instead for 
Did you mean: 

Phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE! ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP

Former Member
0 Kudos

Hi all,

We are in phase of upgrading our ECC 6.0 system to EHP6 but in reprocessing phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE

I am getting the below error

ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP

Our initial size of PSAPTEMP was 2GB and after getting this error I extended it by 1 GB but stll getting the same error.

Please suggest how to proceed in this. Please see the attached  log files for same.

Our environment is AIX 6.1, Oracle 11.2.0.3

Regards

Sukhwinder

Accepted Solutions (1)

Accepted Solutions (1)

ashish_vikas
Active Contributor
0 Kudos

generally PSAPTEMP should be equal to or more than largest table in your database.

So please extend PSAPTEMP more.. make it equal to size of D010TAB.

Former Member
0 Kudos

Thanks Ashish,

Problem is resolved by increasing 2GB more to PSAPTEMP, actually Index D010TAB-1 was expecting size 4.6GB in temp.

Thanks for your valuable suggestion.

Regards

Sukhwinder

Answers (0)