Answer / garry

temporary tablespaces are used for sorting operations

and
permanent tablespaces are tablespace that related to system
or sysaux datafile (system and sysaux are mandatory datafiles)



note :-u can not create dictionary manage tablespace in
database which is created thru dbca

Answer / guest

1.Temporary tablespace is locally managed tablespace
Permanent tablespace is dictionary managed tablespace
2. when an extent is allocated or freed for reuse changes
occurs in tables.In case of Temporary tablespace changes
happen in bitmaps but in Permanent tablespace System Tables
gets updated.
3. Temporary Tablespace automatically tracks adjacent free
space.

HOW TO SPOT AHIERARCHY?

0 Answers  

---

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

0 Answers  

---

what is correlated subquery

3 Answers  

---

how to write customizations in po

0 Answers   Ernst Young,

---

In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record

2 Answers   Syntel,

---

Give the reasoning behind using an index.

2 Answers  

---

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

0 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

10 Answers   TCS,

---

Explain an ORA-01555

2 Answers  

---

What is autocashrule set? : oracle accounts receivable

0 Answers  

---

How do you add a data file to a tablespace?

1 Answers  

---