cancel
Showing results for 
Search instead for 
Did you mean: 

ora-00959: tablespace 'psaptemp' does not exist

Former Member
0 Kudos

Dear All;

during the installation of SAP ERP 6.0 on Suse Linux I faced the error: ora-00959: tablespace 'psaptemp' does not exist at the phase create database schema.

I am afraid that I do this manually then this might affect the installation. Shall I do it or would you recommend another issue. Note: all the previous installation phased went fine with no issues.

Best Regards

~Amal Aloun

Accepted Solutions (1)

Accepted Solutions (1)

former_member206552
Active Contributor
0 Kudos

Hi Amal,

Personally I would create it manually and restart the sapinst with continue as it should pick up that the tablespace excists and continue

Best Regards

Marius

Former Member
0 Kudos

Hi Amal,

Please run the below command:

CREATE TEMPORARY TABLESPACE PSAPTEMP TEMPFILE 'E 😕 oracle/ORC/sapdata3/temp_1/temp.data1' SIZE 500M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE unlimited EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP;

Hope this will help you out.

Thanks

Ajitabh

Former Member
0 Kudos

Dear All;

With your help I was able to fix the error ora-00959

What I did is using the following statement to create PSAPTEMP manually:

create temporary tablespace PSAPTEMP tempfile 'oracle/SID/sapdata1/temp_1/temp.data1' size 5M reuse autoextend off;

I made sure that the location oracle/SID/sapdata1/temp_1 exist so it can be able to create inside it.

i did not have the folder temp_1 so i created it using the comman mkdir temp_1

After that the issue went well

Thanks for all the help.

Best Regards

~Amal Aloun

Answers (3)

Answers (3)

Former Member
0 Kudos

Did you install your database when sapinst paused and prompted you to do so?

Reagan
Advisor
Advisor
0 Kudos

Hello

Most probably this is a test environment and the system was refreshed recently, and after the refresh the PSAPTEMP was not re-created. (Just guessing)

Check whether the PSAPTEMP is present

select NAME from v$tablespace;

Now check for the PSAPTEMP temp files

select * from v$tempfile;

Check whether there is any directory by the name temp in any of the sapdata file system.

If yes re-create the PSAPTEMP from the SQL.

Eg: ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/SID/sapdata1/temp_1/temp1.data' SIZE 5544M REUSE AUTOEXTEND OFF;

Good Luck

RB

former_member215981
Active Participant
0 Kudos

Hello,

Could You please refer sap note -: 1120872.

15/DEC/05       4    unable to assign default tablespace to user: ...
ORA-00959: tablespace 'PSAPSR3USR' does not exist<<<<<<<<<<<<<<<<<<

Best Regards,

Yong Luo