Skip to Content
author's profile photo Former Member
Former Member

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

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

DBCLONE.txt.zip (595 B)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 27, 2014 at 11:31 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.