what is the use of psaptemp table space?if we delete all the
data files in temporary table space will oracle throws any
error?
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
Hi Shridher, Would you please send me an SAP CRM question and Answer to siri.testing@gmail.com Thanks, siri
What is process for applying patches?
Where do you check transport request logs?
I need to change the Company address parameters of a user.
The path is SU01 ->
dear friends, HOW TO CONFIGURE INTO ABAP WEB DYNPRO AND ADOBE OF ECC6.0 R/3 IDES SYSTEM?
Explain segment?
How can you define login policy for users in sap system?
How do you check the installed software components and product versions on sap system?
1.how to retrive corrupt file in back up ? 2.what post actives of patching 3.how increase the file size in unix
What are the key activities that you perform as part of sap basis support?
How you can disable the ‘import all’ button on stms for the queues?
What will you do if u got Update failure?
What is ocm and how to apply ocm patches?
Do you have done System copy? What are the steps?
How to perform the transport?