temp tablespace problem

[Former Member]

hello gurus

i installed solution manager system with oracle 10g but problem is after installation psaptemp is showing size 0mb in sap level but os level it is showing 1gb

name size(mb) free(mb) used(%) extend total size

PSAPTEMP 0,00 0,00 0 NO 0,00

(dbo2 showing like this)

here another problem is brtools not working

psaptemp now not using.what i do

[former_member227600 · Accepted solution]

hI,

run the following command .

login as ora<SID>

sqlplus /nolog

connect /as sysdba

than you will come at command prompt

sql>alter tablespace PSAPTEMP 'path of the file' add tempfile reuse;

than go to db02 and click on refresh.

karan

[Former Member · Accepted solution]

hello karan that syntax is not correct

[former_member227600 · Accepted solution]

Hi,

Can you paste the sql query which you typed.

karan