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 many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,




Which autogrowth database setting is good? : sql server DBA

0 Answers  

what do you understand by fine-grained auditing?

0 Answers   Oracle,

What command would you use to create a backup control file?

2 Answers  

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories