what is the use of psaptemp table space?if we delete all the
data files in temporary table space will oracle throws any
error?
- 2 Answers
- 21263 Views
- I also Faced
- E-Mail Answers
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
Can you change the profile parameter in the os level? Which one is advisable why?
What is JVM switch. Why JVM switch is required ?
1.how to retrive corrupt file in back up ? 2.what post actives of patching 3.how increase the file size in unix
What are steps for DB Refresh?
Is there a difference between user ddic and sap_all/sap_new?
What is an interface in SAP?
Explain deletion flag. Where is it used in archiving process?
what are the current support stack levels at market place?
What is ocm and how to apply ocm patches?
What are patches you applied?
Can anyone forward me EP faqs to the following mail id: hakeem99khan@gmail.com Thanks in advance
Have you done any parameter changes using configtool and visual admin tool?
Explain what is “data sets” in sap?
I want to let sap skip printing cover pages during printing for any kind of report. How can this be done?
How database extend?
