What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
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 |
difference of using cursor for loop and open,fetch,close.which one is better
What are different types of receipt reversals ? Explain them : oracle accounts receivable
What is an Oracle database Partial Backup?
What is the disk migration? what is the steps involved in oracle disk migration?
What is the Query Optimizer. How you optimize your qeury.
HOW TO SPOT AHIERARCHY?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
How would you go about generating an EXPLAIN plan?
What is the difference between recovery and restoring of the oracle database?
How do you switch from an init.ora file to a spfile?
How to find locks exists in a table or not?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?