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

What the different types of replication and why are they used? : sql server DBA

0 Answers  

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

What is blocking and how would you troubleshoot it?

1 Answers  

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

what is incremental checkpoint?

1 Answers   CTS,

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

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  

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  

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

what is difference between user managed backup and rman backup?

1 Answers   CTS,

For more DB Administration Interview Questions Click Here
Categories