Explain an ORA-01555

Question Posted / guest

2 Answers
6810 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Explain an ORA-01555..

Answer / daid kumar

When we Perform the larg DML operation on a table then this
Error is occure
ORA-01555 snapshot too old
to remove this error in 8i or below version You have to
increase the size or rollback segment
and in above version You can Increase the Size Of Undo
tablespace

Is This Answer Correct ?

8 Yes

4 No

Explain an ORA-01555..

Answer / ashok

increase the size of undo tablespace
increase retention period

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More DB Administration Interview Questions

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers

Give two examples of referential integrity constraints.

2 Answers

what are the differences of where and if in SAS?

0 Answers

How would you determine the time zone under which a database was operating?

2 Answers

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers

when does an alert gets signaled?

0 Answers Oracle,

how can you create a user-defined lock?

0 Answers Oracle,

wat is global index and local indes

1 Answers Oracle,

What would you do with an "in-doubt" distributed transaction?

0 Answers

What is transparent data encryption? : sql server DBA

0 Answers

how can you implement fine-grained auditing?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here