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

[Former Member]

hi experts

I installed ECC 6.0 with oracle 10.2.1.0.after i did patches(basis,abap,appl) to the sap.i scheduled client copy i got error

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

i checked in DB02 it shows

Tablespace name Size(MB) Free(MB) Max. extents Min. Extent

PSAPTEMP 0.00 0.00 0 1.000

what is the solution for this can i increase the size of temp tablespace

[markus_doehr2 · Accepted solution]

>

> hi experts

>

> I installed ECC 6.0 with oracle 10.2.1.0.after i did patches(basis,abap,appl) to the sap.i scheduled client copy i got error

10.2.0.1 is not supported - you need to at least install 10.2.0.2 plus the latest interim patches, better use 10.2.0.4

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

> i checked in DB02 it shows

>

> Tablespace name Size(MB) Free(MB) Max. extents Min. Extent

>

> PSAPTEMP 0.00 0.00 0 1.000

>

Yes - you can add a tempfile.

Markus

[Former Member · Accepted solution]

hi markus

i installed already 10.2.0.2 patch.i added tempfile in sqllevel but it shows in OS level it doesn't show in SAP level or database level(DB02).

[markus_doehr2 · Accepted solution]

Did you add it with BR*TOOLS?

Markus

[Former Member · Accepted solution]

hi markus

i tried with BRtools it didn't success.thats why i did in sqllevel(login as sysdba).i added datafile but in sap level or db level it is not showing again it is showing 0.00bytes its size.

Edited by: vasu k on Nov 1, 2008 9:05 AM

[markus_doehr2 · Accepted solution]

Check note 659946 - FAQ: Temporary tablespaces, point 10.

Markus

[former_member227600 · Accepted solution]

Hi ,

Please go thorugh the following thresd

[;

karan

[Former Member · Accepted solution]

hi karan

previousyhat problem i posted there.that problem was not solved thats why again i posted.that time u said ''reuse'' this command not in sqllevel

[Former Member · Accepted solution]

hi markus

thanks for this but my problem is not solved

[markus_doehr2 · Accepted solution]

Please check if you have all relevant corrections for DBACOCKPIT (which is called when you execute DB02):

1028624 - Overview of DBA Cockpit for Oracle

Some jobs must run in order to refresh the displayed data. Usually they run once a day.

Markus

[Former Member · Accepted solution]

Hi,

The syntax of the sql command to reuse the tempfiles of PSAPTEMP is the following:

alter tabelspace PSAPTEMP add tempfile '<full_path>\temp.data1' reuse;

Try also the following:

alter database default temporary tablespace PSAPTEMP;

Regards,

Konstantina

[Former Member · Accepted solution]

hi Konstantina

already i typed in sqlprompt but it said reuse'' command is not in sqllevel

[Former Member · Accepted solution]

Hi vasu,

Do you actually have a tablespace PSAPTEMP at your system? Furthermore, is it the default temporary tablespace of your database?

Please execute the second sql command I mentioned above:

alter database default temporary tablespace PSAPTEMP;

If you get the message "database altered", then it means that your system was using another tablespace as temporary (usually SYSTEM). In that case, you can restart your client copy.

Regards,

Konstantina