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
-
You can set the number of incorrect login attempts and then system can end the session or can also lock the user account if parameter value...
-
You can upgrade the SAP Host Agent by running saphostexec -upgrade from the directory to which you extracted the downloaded SAPHOSTAGENT...
-
SAP Fiori: My Inbox - Troubleshooting + FAQ If you are facing issues setting up or using My Inbox, this document can help you. Frequ...
-
How to find which process is locking a file or folder in Windows For Windows 7, 8 and 10, Windows Server 2010 you can use the built-in R...
-
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...
-
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...
-
Introduction July 2014: This article consolidates the information on Diagnostics Agent Maintenance Procedures, that was previously access...
-
Often in business scenarios, there will be requirements which cannot be transported and which have to be modified directly in respective ta...
No comments:
Post a Comment