what is the use of psaptemp table space?if we delete all the
data files in temporary table space will oracle throws any
error?
- 2 Answers
- 21483 Views
- I also Faced
- E-Mail Answers
Answer Posted / shashisy
A temporary tablespace is mainly required for the
intermediate storage of temporary data during certain
database actions, for example:
Sorting/aggregation with CREATE INDEX, SELECT ...
DISTINCT, ORDER BY, GROUP BY, UNION, INTERSECT, MINUS (when
the memory area defined using SORT_AREA_SIZE is insufficient)
If data files are deleted it throws following err
ORA-01652: unable to extend temp segmen
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
can any send unix admin doc? if u have please send it to chanduk29@gmail.com
I want to change five dialog work processes into batch. Where can I do this?
What is the difference between asynchronous and synchronous transport?
Error in the phase import_proper while applying support packages?
What is XI3.0? Explain XI
How you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?
What are the key responsibilities of sap basis administrator?
steps to congigure CMS in XI ?
How many types of work processes?
What is a developer key? and how to generate a developer key?
Explain domain controller?
Why do you use DDIC user not SAP* for Support Packs and SPam?
What are the different types of rfc and explain what transactional rfc is?
What is the system's configuration required to implement SAP.
you want to take sap backup using brtools. How would you do that?
