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
difference of using cursor for loop and open,fetch,close.which one is better
What is Restricted Mode of Instance Startup in Oracle?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
key flexfield structure
How would you go about increasing the buffer cache hit ratio?
What do you mean by hz_ in customer tables? : oracle accounts receivable
Explain the use of table functions.
Can we modify approve purchase order?if yes what is navigation?
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
HOW TO SPOT AHIERARCHY?
Explain about party and customer in ar : oracle accounts receivable
What is the disk migration? what is the steps involved in oracle disk migration?
how to replace not in with not exist?