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
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
Differentiate between transaction type and transaction source? : oracle accounts receivable
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?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
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
difference of using cursor for loop and open,fetch,close.which one is better
What do you mean by Oracle MEDIA RECOVERY?
3. Steps in UAT?
What is an Oracle database Partial Backup?
8. Supporting AP, AR and GL?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What is auto invoicing? : oracle accounts receivable