What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
- 2 Answers
- 20971 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
What is db_recovery_file_dest in oracle? When do you need to set this value?
Where in the Oracle directory tree structure are audit traces placed?
key flexfield structure
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
what is the link between suppliers and banks in ap module in oracle apps? And also query?
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
Explain how to close periods in ar. : oracle accounts receivable
what is semphore explian it?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
What are different types of receipt reversals ? Explain them : oracle accounts receivable
How do you create a credit note against an invoice? : oracle accounts receivable
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
Explain the use of table functions.
