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

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

1 Answers   IBM,

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

what is difference between user managed backup and rman backup?

1 Answers   CTS,

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

How do you add a data file to a tablespace?

3 Answers  

what is the use of ocr?

0 Answers   Oracle,

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

Can you redefine a table online?

0 Answers   Oracle,

how can you record information about current session?

0 Answers   Oracle,

What does coalescing a tablespace do?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories