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 |
i cant find the user TMSADM in my system after the tms single system configuration.can any one tell me the reason
what is the difference with oracle 9i and 10g?
How to monitor user accessed transactions (Tcode) day wise?
How you will get help from OSS notes?
How u will assign Logon Groups?where u find logo.ini
are any other tools other than SAP used to manage transport ? if so please provide details .
what do you do with solution manager in an R/3 support project?
What are Homogenous system copy and Heterogeneous system copy and how you will do that?
Can you change the profile parameter in the os level? Which one is advisable why?
what type of files are created during the export?
How to check cpu usage in EP?
How to define instances and operation modes?