Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is dbcc? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How do you open a cluster administrator? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is a correlated sub-query? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What are the operating modes in which database mirroring runs? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What is the default port no on which sql server listens? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what is a user-defined lock?
