Re: ORA 01555

From: Dave Wotton <Dave.Wotton_at_dwotton.nospam.clara.co.uk>
Date: Sat, 22 Jan 2000 11:47:25 GMT
Message-ID: <hNgi4.10092$UL1.215024@nnrp4.clara.net>

Venu Nair wrote in message <388590E3.5ACE3C64_at_talentdev.ch>...
>Hi,
>I have a long running delete transaction which generates the following
>error:
>
>ORA 01555: Snapshot too old.Rollback segment number with name RB5 too
>small.
>
>What is the necessary action to deal with this?

My web-page: http://home.clara.net/dwotton/dba/snapshot.htm answers your problem.

Alternatively you could try searching on Dejanews (http://www.dejanews.com/home_ps.shtml) for other suggestions: this question has been answered hundreds of times in this newsgroup.

Specify: Keywords = "snapshot too old" ( or "ORA-01555" )

Forum = "comp.oracle.databases.server"

HTH, Dave.
--
There's no need to reply to this posting by email, but if you do, remove the "nospam" from my email address first. Received on Sat Jan 22 2000 - 05:47:25 CST