What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?

Answers were Sorted based on User's Feedback



What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?..

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

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?..

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

Post New Answer

More Oracle AllOther Interview Questions

difference of using cursor for loop and open,fetch,close.which one is better

0 Answers   Accenture,


What are different types of receipt reversals ? Explain them : oracle accounts receivable

0 Answers  


What is an Oracle database Partial Backup?

0 Answers  


What is the disk migration? what is the steps involved in oracle disk migration?

0 Answers  


What is the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,






HOW TO SPOT AHIERARCHY?

0 Answers  


I would like to study certification course in Data base adminidtrator then where would i go to study this course?

0 Answers  


How would you go about generating an EXPLAIN plan?

1 Answers   Satyam,


What is the difference between recovery and restoring of the oracle database?

0 Answers  


How do you switch from an init.ora file to a spfile?

1 Answers   HCL, Wipro,


How to find locks exists in a table or not?

1 Answers   HCL,


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?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)