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

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

What is a support package?

0 Answers  

---

How to check SAP Memory status?

4 Answers  

---

what is the purpose of Logon groups? expalin me briefly ?

4 Answers   Infosys,

---

What is the start up Sequence of Dual stack(ABAP+ JAVA) SAP system??

4 Answers   ABC, IBM, TCS,

---

How to fiind if there are an expensive SQL statements running if yes, What to do?

1 Answers  

---

Name some drawbacks of SAP?

2 Answers  

---

What are the different options available for scheduling a background job? What start conditions type can be used?

0 Answers  

---

Explain the system trace?

0 Answers  

---

How to find expensive SQL statement, if found, what should be done?

3 Answers   Wipro,

---

what is the difference between system copy and system refresh?

2 Answers  

---

How do you create a password exception list?

2 Answers  

---

What are the diffrent types of table buffering ? Is it "rollin , rollout ".

2 Answers  

---