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 statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

---

what is the use of home directory???

1 Answers   HP,

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

What the different types of replication and why are they used? : sql server DBA

0 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 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  

---