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
Is excel a database?
How do I check my drivers?
Describe why operational and informational systems are separate.
What is database partition key?
Which free database is best?
What are some disadvantages of a standard language such as sql?
What are the characteristics of database management system?
Why not phenix, the zelinka/otwinoski libraries, etc?
What are the main differences between primary key and unique key?
What are the benefits of database management system?
Which database is best for storing large data?
What do you understand by data independence?
What are some of the important security features of a dbms?
Explain the difference between primary and foreign key?
How to select the first record in a given set of rows?