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 |
what are the pre-requisites to apply support patch?
How can a client be locked?
If you are DEPLOY and UNDEPLOY java patch through SDM so why you need JSPM?
what is logical system ? how to create and why ?
What is the procedure to apply Patches?
How you will check whether database is active or not from OS level?
when ever i try to installed sap ecc6.0 sr2 on single system. it show error on phase import abap "Not all objects are successfully processed. DIAGNOSIS: for details see output file with invalid object invalid_objects.txt and log file object_checker.log . SOLUTION: normally it indicate the data load error but in some special cases( for example if some object were created or loaded externally) you can press ok to continue" here error sentence is complete. pls tell what actual error its? is it kernel file related?
If you have a long running job how do you analyze?
How to install multiple Central Instances on the same physical machine?
Hai which kernel version, and patch version and now in real time we need to apply? ie means which version is now running on real time?
What is the exact meaning of ASAP?
we all know that load balancing is done by logon groups. can any tell how can we add users to logon groups