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 |
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
Explain reference and service user in sap. What are their uses?
What are the diffrent types of table buffering ? Is it "rollin , rollout ".
what is the use of psaptemp table space?if we delete all the data files in temporary table space will oracle throws any error?
Hi Shridher, Would you please send me an SAP CRM question and Answer to siri.testing@gmail.com Thanks, siri
How u will apply OCS patches? If a user wants to execute a background job immediately but there is no Background work process available. How u will do? How you will do client copy? If SAP * user is not available at all in your system then how u will do client copy?
8 Answers Bosch, IBM, Infosys,
What are the transport routes?
How you will get help from OSS notes?
What the immediate steps if the instance did not came up after restart in both AS ABAP and AS Java?
What is R/3? and what is basis version?
Background jobs scheduling possible for operating system level in SAP Basis. discribe the details
Hi, I want to know, the detail procedure of Homogeneous System Copy and Heterogeneous System copy stepwise. Can anybody help me //