Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?

Question Posted / daid kumar

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


Please Help Members By Posting Answers For Below Questions

What do you mean by dml compiler?

990

What is big data in database?

830

What is normalization in database with example?

839

What are the advantages of a database?

920

What is rdbms and its types?

822

What is environment of openedge?

859

What are the components of rdbms?

871

What are the types of tables in database?

917

Explain what is a deadlock and mention how it can be resolved?

826

What are cursors give different types of cursors?

884

What is a distributed database?

973

I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.

2123

What is the best database software?

842

Mention a query to calculate the even and odd records from a table

907

What are the characteristics of database?

837