Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?
- 1 Answers
- 5970 Views
- I also Faced
- E-Mail Answers
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 stored-procedures? And what are the advantages of using them.
What do you understand by data redundancy?
What are types of dbms?
What is an extensible database?
What are records and fields in a database?
What are the 4 main objects of a database?
Discuss transparent DBMS?
Explain degree of a relation?
What is data sparsity and how it effect on aggregation?
What is third normal form?
What is the full meaning of dbms?
What is db flush?
What are the advantages of a database?
Where is database stored?
What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?
