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

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

---

what is the differnce between process and thread ?

1 Answers   IBM,

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

Explain about your sql server dba experience? : sql server DBA

1 Answers  

---

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

1 Answers  

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

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

1 Answers  

---