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

Mention how deadlock can be resolved?

0 Answers  

What is difference between database and server?

0 Answers  

What is db dialect?

0 Answers  

What is the use of drop command and what are the differences between drop, truncate and delete commands?

0 Answers  

What is a 3nf table?

0 Answers  

What entity means?

0 Answers  

What are rdbms concepts?

0 Answers  

What is ddl in dbms?

0 Answers  

Describe two phases of Two-phase commit ?

2 Answers  

How big is google's database?

0 Answers  

How can we tune if buffer busy wait issue comes in oracle?

1 Answers   IBM,

What are the Roles and responsibilities of database administrator?

0 Answers  

For more Database Management Interview Questions Click Here
Categories