Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
- 2 Answers
- 22423 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 are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode 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.
You have just compiled a PL/SQL package but got errors, how would you view the errors?
what is correlated subquery
pl help me, i want oracle HRMS training institute address,in chennai
wht r the base tables & primary key for BOM& WIP modules
i want to know about the javaBean.what is its purpose and how it can use in Forms.
What is the Symbol use for Inner Join
what are basic modules required to implement oracle application in any oraganisation?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What is the disk migration? what is the steps involved in oracle disk migration?
What Are Cross Validation & Adi?
Oracle General 
