What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?
- 1 Answers
- 5750 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 are the advantages of a database?
What exactly is a database?
Explain the different types of languages that are available in the dbms?
Describe the difference between data and database administration.
Why do we need database?
What is sql in database management system?
Enlist the disadvantages of query.
What is db flush?
Which database is best for storing images?
is it sufficient to normalize a database up to 3NF?
What are the steps involved in Database Shutdown ?
What are the parts of a table?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
