What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?
Answer Posted / daid kumar
In The case of Very large transaction oracle gives the
Error:-ORA-01555 "snapshot too old"
in this case we have to increase the size of lback segment
and we can assign particular one segment for that
transaction.
before transaction we write
SET TRANSACTION USE ROLLBACK SEGMENT <seg name>
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the three main types of models?
What is drivermanager getconnection?
What is advantages of progress actional?
What is data model in dbms?
Is file system a database?
describe middleware applications that ease the connection of databases to web?
Is excel a database?
What is data sparsity and how it effect on aggregation?
What do you mean by e-r model & object-oriented model?
What is difference between database and spreadsheet?
What is the use of drop command and what are the differences between drop, truncate and delete commands?
What is a database in business?
What is a concurrency problem in dbms?
What do you mean by query evaluation engine?
What is meant by database server?