What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
Answer Posted / 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.
| Is This Answer Correct ? | 7 Yes | 18 No |
Post New Answer View All Answers
what is the link between suppliers and banks in ap module in oracle apps? And also query?
types of receipts and detail desription about recipts and tables effected by receipts?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
please send me oracle pl/sql exp resume. and also faqs...
What are different types of receipt reversals ? Explain them : oracle accounts receivable
What view would you use to determine free space in a tablespace?
What Are Cross Validation & Adi?
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.
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
What is Tax Categories?
How would you determine what sessions are connected and what resources they are waiting for?
3. Steps in UAT?