Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?
- 1 Answers
- 6052 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 is the best database management system?
5) Which acid property will effect when we use commit in trigger?
What are 3 types of databases?
Can you export a table along with partition?
What is Normalization and its different forms?
write a query to retrieve the last day of next month in oracle.
How to deactivate triggers?
Explain why an information gap exists in most organizations.
What are the 3 types of relationships in a database?
What are the advantages of database system?
Which database is best for storing large data?
How does a database partition work?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
