orra 1555 what is this error,why it is occur?

Question Posted / rew

2 Answers
5281 Views
Mphasis, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

orra 1555 what is this error,why it is occur?..

The "ORA-01555 snapshot too old" error, which causes user
transactions to fail, is a nightmare for Oracle DBAs and
developers. It usually occurs after queries or batch
processes have been running for a long time, which means
you can lose many hours of processing when the error crops
up.

Is This Answer Correct ?

5 Yes

0 No

orra 1555 what is this error,why it is occur?..

Answer / kittu

The ora-1555 is too old snapshot. In order to fix this e need to increase undo_retention & undo tablespace size

Is This Answer Correct ?

2 Yes

2 No

Post New Answer

More DB Administration Interview Questions

what is a crs resource?

0 Answers Oracle,

what do you understand by fine-grained auditing?

0 Answers Oracle,

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers Oracle,

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers

How to start SQL Server in minimal configuration mode?

1 Answers

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers IBM,

How can we know the exact updation date of a particular database?

2 Answers Satyam,

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers TCS,

how can you process messages in order asynchronously?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here