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...
-
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...
-
SAP main oracle notes SAP Note Description 1654734 Extended Support contract required for 10.2.0.5 PSU and SBP 1636...
-
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 ...
-
How to check the database size ? How to check in SAP, the number of tables and indexes in database and their sizes ? How to check ...
-
To configure Early watch alert some specific settings to be done at managing system Solution manager system and satellite system( or manag...
-
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...
No comments:
Post a Comment