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.