If DB will Create Which table-space is Used for temporary purpose?
By: Sugandh | 22 Jun 2015 5:56 pm | 515 times viewed | 0 Comments
May I know that if we are not specifying temporary tablespace at beginning of db creation what will happen to db will create or not?
And if db will create which tablespace is used for temporary purpose?
Thanks in advance.
No Comments Posted for this Article.
SAP to Re-Engineer the Indian Postal ServiceMost of us would not be aware of the fact that the Department of Posts has been in existence for more than 150 years. The Department has touched the lives of million of Indians ever since it started its operations, right from delivering letters to their near and dear ones, enabling them to send...
SAP Assures Smooth Moves in GST for Indian CompaniesSAP Assures Customized Solutions for Enabling Indian Companies' Smooth Moves in GSTAn important subsidiary of SAP SE, also known as SAP India, has now reaffirmed its assurance to partners and customers in relation to the reforms linked with Goods and Service Tax (GST) in the nation. To this...
Important ABAP DATA DICTIONARY Interview QuestionsDATA DICTIONARYType of a table or structureThe table type determines how the logical table description defined in the ABAP/4 Dictionary is reproduced on the database. There are the following table types: transparent table structure append structureFor internal purposes, such as storing control...
Can We Create Temporary Tablespace Offline?
Hello Experts,We can create more than 1 temporary tablespace but we can kept 1 at time default. So except default temp. tablespace can we offline other temporary tablespaces. If it so then how can we...
Trying to find who is using temporary tablespace
Hello all, My db version is : 10.2.0.4 and 10.2.0.1 I am trying to find who is using temporary tablespace but I cannot trace any user. When I am storing 3 million records in my database I tried...
Oracle DB (EE) & Shareplex
Hello All, I was looking for benchmarking details or probably to discuss with someone about Shareplex tool of Quest (now DELL) to be used for CDC mechanism. I have a project where IBM CDC or GG...