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


Please Help Members By Posting Answers For Below Questions

What are the three main types of models?

561


What is drivermanager getconnection?

680


What is advantages of progress actional?

575


What is data model in dbms?

553


Is file system a database?

561






describe middleware applications that ease the connection of databases to web?

585


Is excel a database?

592


What is data sparsity and how it effect on aggregation?

576


What do you mean by e-r model & object-oriented model?

602


What is difference between database and spreadsheet?

555


What is the use of drop command and what are the differences between drop, truncate and delete commands?

658


What is a database in business?

613


What is a concurrency problem in dbms?

603


What do you mean by query evaluation engine?

595


What is meant by database server?

557