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
You want to find out which users have an access to a particulat transaction. How would you do that?
you want to take sap backup using brtools. How would you do that?
i want my company code and controlling area defaut as 'ABC" through out SAP what to do ? and my plantcode also default to some value
What is the difference between developer trace, system log and system trace?
What is the use of patches in sap system? Could you name few common patch types?
describe how to setup a printer in SAP or where they would look to research why a user/users can not print?
What is sap netweaver administrator tool?
How many times bdls transaction executes for 2 clients
Where XML file is generated in solution manager?
What are the activities you done in PI?
How to set predecessor relationship between two transport requests?
What is the use of commit value while deleting jobs in sap system?
What is the folder it will ask to install oracle?
I'm getting the following runtime error in IDES "DYNPRO_MSG_IN_HELP". GUI is 720 final release and patch level:0
Some transactions in sap are seen as customizing, for instance ovrf (updating routes). In some systems this is set as master data and can be set open. Where do you do this?