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
Hi, Cansomeone please send the system refresh doc , it's very urgent for me. Thanks in advance.
How to analysis abap dumps?
What are the activities you done in PI?
Have u applied patches what is the transaction code?
What are the errors you got while applying support pack?
How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.
What is development class? Why to create the development class?
What are the daily activates?
Which transaction do you use to check buffer statistics ?
What is ocm and how to apply ocm patches?
How to apply java stacks ? expalin step by step prcoess
Explain what is sap ides?
How you can apply sap notes to sap system?
What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?
Explain kernel upgrade?