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...
-
Use RZ10 transaction code to Manage Profiles of all Instances running in a SAP R/3 system. when you run RZ10 the following screen will ape...
-
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 ...
-
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...
-
Introduction July 2014: This article consolidates the information on Diagnostics Agent Maintenance Procedures, that was previously access...
-
How to export user master and authorization profiles in SAP system? Which tcode is used for user master export in SAP system? Which...
-
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