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 ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is client administration in sap system? Why do we use multiple clients in sap system?

1231


Using Tc SGEN I have generated 74% job and later I have terminated the job. I wish to start generating from where it stopped I have refreshed but to no chance, nothing was done. How should I further proceed so as to complete the remaining job?

1111


dear friends, HOW TO CONFIGURE INTO ABAP WEB DYNPRO AND ADOBE OF ECC6.0 R/3 IDES SYSTEM?

4486


what is the use of psapundo tablespace? what is the error ora -01555 represents.how can u prevent this error?

12129


what is the difference b/w 4.7EE & ECC5.0?

2416


How to see when were the optimizer stats last time run?

1223


Where do you download trail version of sap ecc, what is sap cal?

1100


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

1061


Is there a difference between user ddic and sap_all/sap_new?

1622


What will happen during the export process?

2060


What are steps for DB Refresh?

1883


In the Sap Easy Access Menu I see the menu System -> User Profiles ->Own Data. Other options Hold Data is to keep data values that you have entered in a field of an application for the duration of the session; SET DATA not to overwrite the data and DELETE DATA to delete the set data. Can somebody explain me the Hold Data, Set Data and Delete Data with examples, i mean giving an example of fields?

3829


If brtools is not working how you will add datafile?

2529


If client copy is stopped in middle, what happens if you want to start it again?

2086


Is system user sap basis consultant and dialogue user other user like fico, hr, mm user?

1535