What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
- 2 Answers
- 21672 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 7 Yes | 3 No |
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.
| Is This Answer Correct ? | 7 Yes | 18 No |
Is it possible to drop a column in a table which contains only one column? How?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
what is shared memory?
What view would you use to determine free space in a tablespace?
What is database schema?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What is the importance of batch source set up in ar? : oracle accounts receivable
How would you determine who has added a row to a table?
what is semphore explian it?
Can we get the deleted Record again if the delete transaction has been committed.
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
How would you force a log switch?
Oracle General 
