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 ? | 10 Yes | 1 No |
Post New Answer View All Answers
How to add authorizations, how you will maintain profiles?
How to define logon groups?
How to delet a table in sap. How to move a table from one location to another.
Explain what are the functional modules used in sequence in bdc?
What is a background processing batch scheduler?
How many times bdls transaction executes for 2 clients
What is luw (logical unit of work)?
What is the difference between st06 and st03?
What is transport domain?
What is MySAP?
Is system user sap basis consultant and dialogue user other user like fico, hr, mm user?
How will go about doing a client copy ?
how can i change access to a user who is having access for SPRO display only to change access in sPro
What is SSO? How to configure SSO?
How u will give new authorizations?