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 increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

How can you gather statistics on a table?

3 Answers  

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

how will you see when the database was started using sql prompt?

2 Answers   IBM,

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

2 Answers   Satyam,

what is logical system in sap basis

0 Answers  

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  

what is difference between user managed backup and rman backup?

1 Answers   CTS,

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

Can you redefine a table online?

0 Answers   Oracle,

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

For more DB Administration Interview Questions Click Here
Categories