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 is the role of “ application server” ?
What is the main difference between sap and erp.
what is SOLUTION MANAGER?
How to login in o.s level with <sid>adm user in sap basis ? please tell me step by step ?
What are the activities you done in EP?
How to creat Profiels Manually?
What are the Pre- requisite for system copy?
Which java tools can be used for installation of Java patches?
Why https is considered safer than http?
Example you have 6 sap application servers, I want to monitor all the application servers. How to configure a CCMS?
how can i integrate ecc6.0sr3 with bi7 or netweaver 7 into single sap system.? pls give me some step. i know installation.
Can i lock a particular table.If yes then how ?