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 use of foreign key?

0 Answers  

Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.

0 Answers  

What is view dbms?

0 Answers  

Is driver a software?

0 Answers  

What is an extensible database?

0 Answers  

What is normalization and what are the different types of normalization?

0 Answers  

Suppose database is running slow, what will you do?

0 Answers  

how Data is stored in a file so that Direct Searching can be performed

0 Answers   HCL,

Define the following terms 19. (i) Database 20. (ii) Database Management System 21. (iii) Data Model 22. (iv) Scheme 23. (v) Data independence

1 Answers  

What is a DATABLOCK ?

2 Answers  

What is the most popular database?

0 Answers  

Describe two phases of Two-phase commit ?

2 Answers  

For more Database Management Interview Questions Click Here
Categories