what is the use of psaptemp table space?if we delete all the
data files in temporary table space will oracle throws any
error?
- 2 Answers
- 20938 Views
- I also Faced
- E-Mail Answers
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
What is the purpose of tdevc ?
How you will do that?
I also wanna work with Webdynpros? What are the requirements? I mean SAP 4.7 ee or ECC 5 or 6? Netweaver developer Studio? Also with win 2003 i have the activation problem every month. SO do i get a cd that doesnt ask for the activation? i have win 2000 but can it be installed on HP pavilion laptops that are coming preinstalled with Vista OS?
Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?
Is it possible to install sap patches when other users are online?
What is sap ides?
Is there a way to perform sapgui 640 roll out using a centralized server?
How can you find a list of objects that have been repaired in the system?
what is the difference b/w 4.6c & 4.7EE?
What is JVM switch. Why JVM switch is required ?
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?
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?
Is system user sap basis consultant and dialogue user other user like fico, hr, mm user?
Error in the phase import_proper while applying support packages?
I am attempting to complete a system copy of bw. When I try to go in to rsa1 afterwards I get the error message, "entry in inbound table already exists." What should I do to solve the problem?
