orra 1555 what is this error,why it is occur?
- 2 Answers
- 4287 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / nirav gajjar
The "ORA-01555 snapshot too old" error, which causes user
transactions to fail, is a nightmare for Oracle DBAs and
developers. It usually occurs after queries or batch
processes have been running for a long time, which means
you can lose many hours of processing when the error crops
up.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
how can a session indicate its interest in receiving alerts?
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is the default port no on which sql server listens? : sql server DBA
What is dbcc? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
how can you record information about current session?
What are the different types of indexes available in sql server? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Where would you look for errors from the database engine?
how can you schedule a job in database?
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.
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
