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 are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?

0 Answers   NIIT, TCS,

How to select a random record from a table?

0 Answers  

What is called dbms?

0 Answers  

What is the concept of sub-query in terms of sql?

0 Answers  

What is a Database Schema and Why is It Important?

1 Answers  

10 How to Handle Data Migration Between Different Databases?

1 Answers  

What is database users in dbms?

0 Answers  

What is trigger in dbms?

0 Answers  

what is the diff between dbms and rdbms(what are the 12 rilations in the rdbms).

5 Answers   Satyam,

Difference between file system and relational database.

1 Answers  

Describe and contrast sql and qbe.

0 Answers  

What is use of LOG (Ver 7) option in EXP command ?

1 Answers  

For more Database Management Interview Questions Click Here
Categories