orra 1555 what is this error,why it is occur?

Answer Posted / kittu

The ora-1555 is too old snapshot. In order to fix this e need to increase undo_retention & undo tablespace size

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

1642


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1491


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?

1994


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1585


what are the differences of where and if in SAS?

1662






What are the different types of indexes available in sql server? : sql server DBA

573


What the different topologies in which replication can be configured? : sql server DBA

652


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?

2029


How do you open a cluster administrator? : sql server DBA

579


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1536


who owns the operating system files created by the utl_file package?

562


how does an oracle clusterware manage crs resources?

568


How can you control the amount of free space in your index pages? : sql server DBA

727


How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1653


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.

1233