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 the diffrence between core dba and apps dba?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
what is a crs resource?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is a correlated sub-query? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is the default fill factor value? : sql server DBA
how can you process messages in order asynchronously?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you communicate with operating system files from oracle?
What is the difference between clustered and non-clustered index? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What the different types of replication and why are they used? : sql server DBA
