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

How do you set a primary key?

0 Answers  

which is the best institute to learn Oracle DBA 10g/11g, please advise, someone?

2 Answers  

What is the use of INCTYPE option in EXP command ?

1 Answers  

Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

0 Answers  

Explain what is an Exception ?

1 Answers  

What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?

0 Answers  

What is a sequence in a database?

0 Answers  

is it sufficient to normalize a database up to 3NF?

4 Answers  

What do you mean by transparent dbms?

0 Answers  

What is 2-tier architecture?

0 Answers  

How can I access my database remotely?

0 Answers  

What are the steps involved in Database Startup ?

2 Answers   247Customer,

For more Database Management Interview Questions Click Here
Categories