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
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What is the difference between clustered and non-clustered index? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What is fill factor? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Where would you look for errors from the database engine?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
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
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is transparent data encryption? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
who owns the operating system files created by the utl_file package?
what is logical system in sap basis
What the different components in replication and what is their use? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?