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 >> DB Administration
  2. Suggest New Category

Explain an ORA-01555

Question Posted / guest

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

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

what is grd?

0 Answers   Oracle,

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

what is meant by gateway

1 Answers   IBM,

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

What is the default fill factor value? : sql server DBA

0 Answers  

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

Which autogrowth database setting is good? : sql server DBA

0 Answers  

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

What is blocking and how would you troubleshoot it?

1 Answers  

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

For more DB Administration Interview Questions Click Here
Categories