Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
- 2 Answers
- 22384 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 |
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What is an Oracle database Full Backup?
Explain the difference between a hot backup and a cold backup and the benefits associated with each
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
How can you rebuild an index?
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
8. Supporting AP, AR and GL?
What command would you use to encrypt a PL/SQL application?
What do you mean by hz_ in customer tables? : oracle accounts receivable
how to display last 5 letters from a name (take emp table ename )
Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?
Oracle General 
