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

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

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

2 Answers  

---

If CPU is very slow What can u do to speed up?

1 Answers  

---

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---