What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?



What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?..

Answer / 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

More Database Management Interview Questions

How to write udf s in delphi?

0 Answers  


What is erd?

0 Answers  


Why is the use of dbms recommended?

0 Answers  


What is data modelling techniques?

0 Answers  


What are the different types of languages that are available in the dbms?

0 Answers  


What are the three types of databases?

0 Answers  


how can i get company email id's can anybody answer to this question. bcz it is very important for me, looking for the best answer.

1 Answers  


What is Restricted Mode of Instance Startup ?

1 Answers  


What is record in a database?

0 Answers  


Mention the differences between the clustered and non-clustered index

0 Answers  


what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000

0 Answers   Indian Web Technology,


What are the importance of partitioning in dbms?

0 Answers  


Categories