SAP Knowledge Base Article - Preview

3037238 - ORA-01516 on temporary file

Symptom

When trying to perform any change on any temporary file, the ALTER DATABASE DATAFILE command of choice is issued, like the one below:

SQL> ALTER DATABASE MOVE DATAFILE '/oracle/<SID>/sapdata1/temp_2/temp.data2' TO '/oracle/<SID>/sapdata0/temp_2/temp.data2';
ALTER DATABASE MOVE DATAFILE '/oracle/<SID>/sapdata1/temp_2/temp.data2'TO '/oracle/<SID>/sapdata0/temp_2/temp.data2'
*
ERROR at line 1:
ORA-01516: nonexistent log file, data file, or temporary file
"/oracle/<SID>/sapdata1/temp_2/temp.data2" in the current container


Read more...

Environment

  • Not restricted to any SAP Product
  • Any Oracle RDBMS release
  • Any OS platform

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

ORA-01516, PSAPTEMP , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.