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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

6720


while creating requisitions i am unable to see the list of organisation can anyone help me out ?

1700


Differentiate between transaction type and transaction source? : oracle accounts receivable

669


What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

693


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1485






I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

1817


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

1247


What do you mean by Oracle MEDIA RECOVERY?

719


3. Steps in UAT?

1940


What is an Oracle database Partial Backup?

687


8. Supporting AP, AR and GL?

1801


What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

747


What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

640


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1622


What is auto invoicing? : oracle accounts receivable

650