In order to  add a tempfile into the mounted  opened Oracle RDBMS:
Login to database command line as sysdba 
SQL> connect /as sysdba
Type 
 SQL> ALTER TABLESPACE <TABLESPACE_NAME> ADD TEMPFILE
'PATH_TO_TABLESPACE_FILE' size 32000M reuse;
Example:
SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE
'/oracle/SID/sapdata2/temp_2/temp.data2' size 32000M reuse;
SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE
'/oracle/SID/sapdata3/temp_3/temp.data3' size 32000M reuse;
SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE
'/oracle/SID/sapdata4/temp_4/temp.data4' size 32000M reuse;
This was an easiest way how to add tempfile into Oracle TEMP tablespace.
Subscribe to:
Post Comments (Atom)
Popular Posts
- 
SAP Fiori: My Inbox - Troubleshooting + FAQ If you are facing issues setting up or using My Inbox, this document can help you. Frequ...
 - 
Changing the default trace level of SAP Host Agent SAP Host Agent runs with tracelevel 1 by default. If you need more information to be a...
 - 
SAP Lock Value In USR02 table We use USR02 table for checking the status of an user whether user is locked or not. There are 6 type o...
 - 
RFC connection test in SM59 might give error similar to this Logon Connection Error Error Details Error when opening an RFC connection Er...
 - 
How to export user master and authorization profiles in SAP system? Which tcode is used for user master export in SAP system? Which...
 - 
Introduction Document Status The Diagnostics Agent troubleshooting guide used to be available as a PDF document. It is now replaced by ...
 - 
What is spool overflow ? How to troubleshoot spool overflow ? How to delete old spool requests ? How to avoid spool overflow issue ? ...
 - 
Introduction July 2014: This article consolidates the information on Diagnostics Agent Maintenance Procedures, that was previously access...
 - 
SAP kernel has a little part called sappfpar. This little program is used to check whether your SAP profile has already well configured or ...
 - 
Diagnostics Agent Installations Finding Previously Installed Diagnostics Agents To double check, if a Diagnostics Agent is installed yo...
 
No comments:
Post a Comment