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

Explain a checkpoint and when does it occur?

0 Answers  

What is the meaning of flat file database?

0 Answers  

What does a database contain?

0 Answers  

What is file manager?

0 Answers  

What is 2nf in dbms?

0 Answers  

What is a checkpoint and When does it occur in database?

0 Answers   TryTechnicals Pvt Ltd,

What do you understand by clause in sql?

0 Answers  

What do you understand by the view and mention the steps to create, update and drop a view?

0 Answers  

Describe the Process of ETL (Extract, Transform, Load).

1 Answers  

Describe the difference between embedded and dynamic sql.

0 Answers  

What is oracle block?

0 Answers  

How is view stored in database?

0 Answers  

For more Database Management Interview Questions Click Here
Categories