Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
- 2 Answers
- 22553 Views
- I also Faced
- E-Mail Answers
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 |
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
What is the importance of batch source set up in ar? : oracle accounts receivable
What is supporting issues GL AP and AR?
What is an Oracle database Full Backup?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value
What command would you use to encrypt a PL/SQL application?
Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?
Could you please let me know the interfaces in OM / FA??
What is $FLEX$ and $PROFILES$?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
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.
Oracle General 
