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
For ex: i scheduled one ABAP program as a background job but it was running 10 days, how to analyze the problem?
Where XML file is generated in solution manager?
What are the key activities that you perform as part of sap basis support?
How to assign a mass Tables in Auth Group by using T-code:se54
Can you tell me installation procedure of SAP on UNIX
How will u send mail after completion of backup?
What is Unit Testing in SAP?
A user moved the transport request from dev to qua. How would you trace him?
What is the procedure to applying patches?
What is the need of having Development system?
Explain the system log?
If job is slow?
How client refresh is different than client copy?
I have a requirement from the SD people wherein whenver one runs the tcode F-02 (Enter G/L account Policy : Header Data), they should not get the list of all acounts in the ACCOUNT field. But when i go to pfcg to check for restricting the list, i dont find any pertinet auth field for doing so. Isi t something that we can ( as Basis Admin) do or the ABAPpers to do. Maybe the ABAPpers have to program the screen where in they need to restrict the list options. If not so, lemme know the auth field that has to bet set if any.
What are the errors you got while applying support pack?