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

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

---

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

---

What is the dataguard background process??

1 Answers   iGate,

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

what r the types of backup?

5 Answers   CSC,

---

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

---

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

0 Answers  

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

what is the use of ocr?

0 Answers   Oracle,

---

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

---

what is incremental checkpoint?

1 Answers   CTS,

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---