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.
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...
-
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...
-
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...
-
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 ...
-
SAP kernel has a little part called sappfpar. This little program is used to check whether your SAP profile has already well configured or ...
-
How to perform system refresh in SAP? What are the steps involved in system refresh of SAP system? What is the SAP system refresh pro...
-
SAP diagnostics agents The diagnostics agent is a central component of the SAP Solution Manager system landscape. This page summariz...
-
The main system log , SAP systems can be seen by running transaction SM21 ( Tools-> Administration-> Monitoring-> System Lo...
No comments:
Post a Comment