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 ? | 3 Yes | 0 No |
Post New Answer View All Answers
How would you troubleshoot the 'system seems slow'?
How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.
Where do you download trail version of sap ecc, what is sap cal?
How many times bdls transaction executes for 2 clients
Which are the most frequent errors encountered while dealing with transports ?
Hi Shridher, Would you please send me an SAP CRM question and Answer to siri.testing@gmail.com Thanks, siri
What are the types of transport queries?
Why can't we do it thru some other client?
How you connect ECC to EP?
What are the DVD's Download for implementation?
What is the purpose of support package?
Difference between system refresh and client copy?
How many types of work processes?
How will determine whether your sap server is unicode or ascii ?
What is business kpis ?