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

Can you copy the PROGRAM UNIT into an Object group ?

1 Answers  

Define object-oriented model.

0 Answers  

What is information schema in database?

0 Answers  

Explain 5nf?

0 Answers  

Describe the purposes and advantages stored procedure?

0 Answers  

What is a 3nf table?

0 Answers  

Explain how RDBMS software deals with deadlocks.

1 Answers  

What's the best database software for mac?

0 Answers  

Is a server a database?

0 Answers  

dear sir please provide what question will be asked in CWE in bank it officer

0 Answers  

What is the quickest sorting method to use?

0 Answers  

What is database management system(dbms) and why it is used?

0 Answers  

For more Database Management Interview Questions Click Here
Categories