What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?
- 1 Answers
- 5406 Views
- I also Faced
- E-Mail Answers
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 |
What do you understand by proactive, retroactive and simultaneous update?
What is Library in Forms 4.0 ?
How do you copy a database?
What is the easiest database to learn?
What are the main characteristics of database approach?
What is database management used for?
What is an advantage of a database?
Explain the different types of constraints in dbms?
What is tuple with example?
what is datapump? Difference between exp and expdp?
2 Answers Capital IQ, TCS, WNS,
What is tabular form?
Can we update table which is created from view?
2 Answers IBM, Punjab National Bank,
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
