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 find locks exists in a table or not?

1 Answers   HCL,

---

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

1 Answers  

---

what are important reports in HRMS,GL,AP,AR in oracle apps?

3 Answers   IBM, Pathway Technologies, Satyam, Techtimer, Wipro,

---

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

1 Answers   IBM, Oracle,

---

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

0 Answers   TCS,

---

What are different types of transactions in ar? : oracle accounts receivable

0 Answers  

---

For web applications from which version of Oracle is suitable?

1 Answers  

---

Give two methods you could use to determine what DDL changes have been made.

1 Answers  

---

3. Steps in UAT?

0 Answers   Oracle,

---

Explain an ORA-01555

2 Answers  

---

What is database schema?

4 Answers   Infosys,

---

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

0 Answers  

---