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

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

what is the differnce between process and thread ?

1 Answers   IBM,

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

How can you gather statistics on a table?

3 Answers  

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

What is fill factor? : sql server DBA

0 Answers  

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---