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 |
How to write udf s in delphi?
What is erd?
Why is the use of dbms recommended?
What is data modelling techniques?
What are the different types of languages that are available in the dbms?
What are the three types of databases?
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.
What is Restricted Mode of Instance Startup ?
What is record in a database?
Mention the differences between the clustered and non-clustered index
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?