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
What is fill factor? : sql server DBA
What is dbcc? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what are the benefits of flashback feature?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
Why would you use sql agent? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
what are the performance views in an oracle rac environment?
Which autogrowth database setting is good? : sql server DBA
Explain about your sql server dba experience? : sql server DBA