What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
- 2 Answers
- 20940 Views
- I also Faced
- E-Mail Answers
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
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
HOW TO SPOT AHIERARCHY?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
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
what is difference between inner join & nested query or subqueries
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
What view would you use to determine free space in a tablespace?
What is the use of lockboxes? : oracle accounts receivable
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
as a technical developer in oracle applications which type errors feced in your experience sofar
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
What do you mean by Oracle MEDIA RECOVERY?
