Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are the different types of job status? Can you unschedule an active job?

1196


On a particular system how you can get a list of the users with development access on a particular system?

1164


Can anyone forward me EP faqs to the following mail id: hakeem99khan@gmail.com Thanks in advance

2633


How to delet a table in sap. How to move a table from one location to another.

2347


what is sox and sod in sap ?

1871


How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.

3706


How do you check the users logs in your system and how many sessions each user is generating?

1103


What are the Parameters need to be set when connecting EP to r/3 system what are they?

1908


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?

2344


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?

2547


Is it possible to install sap patches when other users are online?

1070


What are patches you applied?

1298


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.

2182


How to configure TMS?

1885


describe how SAP handles Memory Management?

1168