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.

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

3 Answers  

---

what are the API of GL,PO,AP

0 Answers  

---

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

0 Answers  

---

what is diff between pre insert,on insert,post insert triggers?

1 Answers   IRISA,

---

Where would you look for errors from the database engine?

2 Answers   Fintellix,

---

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers   IBM,

---

how can we send a concurrent program output to the clients through mail or fax give me example.

1 Answers   Cap Gemini,

---

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

3 Answers   HP,

---

Whats the purpose of using Nextval while creating the sequence.

2 Answers   HCL,

---

how to replace not in with not exist?

0 Answers   IBM,

---

What are different types of receipt reversals ? Explain them : oracle accounts receivable

0 Answers  

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

0 Answers  

---