What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?
- 1 Answers
- 5556 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 |
I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?
What is sql and where is it used?
Can files be stored in a database?
What are the features of database language?
Explain the three Level Architecture of the Database System
Is google scholar a database?
Why is rdbms important?
What is second normal form?
What is procedure in database?
what are the differences between network and hierarchical database model?
How to monitor firebird server activity?
Can you explain fourth normal form and fifth normal form ?
-
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)
