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 the use of recording information about current session?
how to restore files with rman?
What is a system database and what is a user database? : sql server DBA
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.
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What are the different types of database compression introduced in sql server 2008? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
how can you get actual data change values from previous transactions in oracle?
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 statistics, under what circumstances they go out of date, how do you update them?
how can you connect from 10g user to 11g user??
What is replication? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How do you open a cluster administrator? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
