Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?
- 1 Answers
- 5995 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 is a key in dbms?
What are some of the important security features of a dbms?
Can anybody give me link for BOXI R3.1 Key please
Why indexing is used in database?
What is index hunting and how does it help in improving query performance?
Define dbms.
What is acid property in dbms?
Have you written applications to retrieve stored images in a table?
Explain the advantages of rdbms?
Operators used in select statements are?
What do you mean by e-r model?
What is the normal procedure followed by a java client to access the db?
What is an extensible database?
Enlist the advantages of normalizing database.
What is normalization in database with example?
