what is the use of psaptemp table space?if we delete all the
data files in temporary table space will oracle throws any
error?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
what are the sap table space names that you see in db02?
What are the regular activities u do in solution manager and how
How to find sap transaction codes?
How to make a copied client from the Client 000 cannot be customized?
What is early watch report?
sap basis training courses @ madiwala bangalore
What is the need of having Development system?
how should I check the Last authorization failed using suim tcode?
You want to transport users between different clients. How would you do that?
What is difference between oracle 9i and oracle 10g?
What are the .sca files and their importance?
How to see the t able entry values?