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
What are the different types of job status? Can you unschedule an active job?
On a particular system how you can get a list of the users with development access on a particular system?
Can anyone forward me EP faqs to the following mail id: hakeem99khan@gmail.com Thanks in advance
How to delet a table in sap. How to move a table from one location to another.
what is sox and sod in sap ?
How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.
How do you check the users logs in your system and how many sessions each user is generating?
What are the Parameters need to be set when connecting EP to r/3 system what are they?
Hi,My name is Saurabh I have done BMS & currently working in Wipro BPO (1 year). I want to pursue my career in SAP. As I am totally new in the IT field(no course & no experience) Please could you suggest whether to do a certification from Certified institutes or Non Certified institutes.What is the difference? Also, Is MBA necessary to do certification from Certified institutes?
How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?
Is it possible to install sap patches when other users are online?
What are patches you applied?
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.
How to configure TMS?
describe how SAP handles Memory Management?