Answer Posted / 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
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what is a user-defined lock?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What are the steps you will take to improve performance of a poor performing query?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What the different topologies in which replication can be configured? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the commands used in dcl? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what is the diffrence between core dba and apps dba?
what is grd?
