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

Why would you use sql agent? : sql server DBA

580


what is the use of recording information about current session?

574


What are the commands you'd issue to show the explain plan for "select * from dual"?

1733


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1874


what is the diffrence between core dba and apps dba?

2091






How do you troubleshoot errors in a sql server agent job? : sql server DBA

569


How do you trace the traffic hitting a sql server? : sql server DBA

846


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1750


What are the different types of upgrades that can be performed in sql server? : sql server DBA

684


How would you go about verifying the network name that the local_listener is currently using?

2764


What are the different ways you can create databases in sql server? : sql server DBA

601


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1705


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?

2180


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

711


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

1838