Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?
- 1 Answers
- 6050 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 do you mean by entity type?
How to retrive a single data from a database
What are the features of a database management system?
What is actional flow mapping?
How is rdbms different from dbms?
What entity means?
How do you notify dbpak about stored procedure?
What is the difference between a catalog and a database?
What are the properties of a primary key in DBMS?
What is the data in a database?
Is google scholar a database?
What is like operator for and what are wild cards?
IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?
What is database bloat?
Explain a tp monitor?
