Answer / guest

Temporary Tablespace is in generally used for sorting
purpose while Permanent tablespace is used to sore
permanent objects

Regards
Abhinav Phadnis

Answer / kranthi

Permanent tablespace is used to store permanent objects etc
temporary tablespace is used for sorting

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

What are the commands used in dcl? : sql server DBA

0 Answers  

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

What purpose does the model database server? : sql server DBA

0 Answers  

---

---

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

Why would you call update statistics? : sql server DBA

0 Answers  

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---