What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?

Question Posted / guest

1 Answers
6123 Views
I also Faced
E-Mail Answers

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 to migrate paradox, dbase or foxpro database to firebird?

0 Answers

What are the features of rdbms?

0 Answers

What are the key constraints in dbms?

0 Answers

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

0 Answers

What is an extensible database?

0 Answers

Define ddl interpreter.

0 Answers

What are the importance of database in banking?

0 Answers

What is the function of DML Compiler?

0 Answers Amazon, iNautix,

Can A CONTROL BLOCK can sometimes refer to a Basetable ?

1 Answers

Explain the advantages of rdbms?