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

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---

how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

---

What is the default fill factor value? : sql server DBA

0 Answers  

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

what is the difference between db2start command and start database manager command?

1 Answers  

---