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

For ex: i scheduled one ABAP program as a background job but it was running 10 days, how to analyze the problem?

1874


Where XML file is generated in solution manager?

1709


What are the key activities that you perform as part of sap basis support?

1111


How to assign a mass Tables in Auth Group by using T-code:se54

2324


Can you tell me installation procedure of SAP on UNIX

2391


How will u send mail after completion of backup?

2143


What is Unit Testing in SAP?

1258


A user moved the transport request from dev to qua. How would you trace him?

1236


What is the procedure to applying patches?

1130


What is the need of having Development system?

1771


Explain the system log?

1081


If job is slow?

1773


How client refresh is different than client copy?

1257


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.

2134


What are the errors you got while applying support pack?

1784