Answer / daid kumar

When we Perform the larg DML operation on a table then this
Error is occure
ORA-01555 snapshot too old
to remove this error in 8i or below version You have to
increase the size or rollback segment
and in above version You can Increase the Size Of Undo
tablespace

Answer / ashok

increase the size of undo tablespace
increase retention period

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

How do you add a data file to a tablespace?

3 Answers  

---

what is a user-defined lock?

0 Answers   Oracle,

---

what is logical system in sap basis

0 Answers  

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

---

---

how to restore files with rman?

0 Answers  

---

what is the use of ocr?

0 Answers   Oracle,

---

what is incremental checkpoint?

1 Answers   CTS,

---

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---

How to make a replica of existing oracle server to another server?

3 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

---