What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
- 2 Answers
- 20991 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 |
Explain the use of table functions.
What are the mandatory setups in setting up a PO in oracle
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
i have marks in table,how to find total?
Can we get the deleted Record again if the delete transaction has been committed.
Explain an ORA-01555
what is semphore explian it?
How would you determine who has added a row to a table?
how to replace not in with not exist?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
Oracle General 
