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 / guest


What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?..

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

Post New Answer

More Database Management Interview Questions

What is tuple with example?

0 Answers  

What is a field in database?

0 Answers  

What is etl process in data warehousing? What are the different stages in 'data warehousing'?

0 Answers  

What is netlib for clipper?

0 Answers  

What is db dialect?

0 Answers  

What built_in procedure is used to get IMAGES in Forms 4.5 ?

1 Answers  

What is correlated subquery in dbms?

0 Answers  

Write a query to remove duplicate rows from a table?

0 Answers  

Is file system a database?

0 Answers  

How can we tune a oracle database if log file sync issue comes

0 Answers   L&T,

What do you mean by transparent dbms?

0 Answers  

How to determine who is and change the owner of database?

0 Answers  

For more Database Management Interview Questions Click Here
Categories