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
How to perform the transport?
What is the purpose of tdevc ?
Why can't we do it thru some other client?
Myself Rahul am MBA(Mkt)having 1.5 years marketing experience.and in SAP-SD for 1 years experience.am looking for job.so pl anywher opening then pl let me revert.
What is the use of commit value while deleting jobs in sap system?
hi friends, in sap screen with 000 client i unable to logon,with 001 client i can login but i want to log on with 000 client how i can loggin with 000 client intial screen ,please can u help me
what are the pre-requisites to apply support patch?
What is the difference between asynchronous and synchronous transport?
Is system user sap basis consultant and dialogue user other user like fico, hr, mm user?
What are the different modules of SAP?
What is a support package? What is its purpose?
Hi i am Ramesh want to know that which course in sap is most suitable for my younger brother who has BSC qualification and is this course is job oriented
What are the different types of rfc and explain what transactional rfc is?
can we give one check for all vendors in automatic payment run? how?
How do you kill a job in SAP?