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...
-
Scope Solution Manager 7.1 SP05 and higher Terminology The term 'host' does NOT designate a network alias. Hosts must have t...
-
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...
-
If you want to exclude a table x from copying in client copy run report RSCCEXPT Goto transaction SA38 , enter the report name and execu...
-
Often in business scenarios, there will be requirements which cannot be transported and which have to be modified directly in respective ta...
-
Introduction Document Status The Diagnostics Agent troubleshooting guide used to be available as a PDF document. It is now replaced by ...
-
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...
-
How to export user master and authorization profiles in SAP system? Which tcode is used for user master export in SAP system? Which...
-
Introduction July 2014: This article consolidates the information on Diagnostics Agent Maintenance Procedures, that was previously access...
-
Connect the Diagnostics Agent to Solution Manager 7.1 using SSL Skip to end of metadata Objective The aim of this wiki i...
No comments:
Post a Comment