Re: Flashback query and ORA-01555, rollback segs

Ben wrote:
> 9.2.0.5 EntEd AIX5L
>
> We are using rollback segments due to the fact that our compatible
> parameter is still set to 8.1.0
>
> On to the problem.
> A user calls and ooops, they've updated 2000 records that shouldn't
> have been updated. I get a call wanting me to recover/restore that
> table from last night's backup from tape. I don't want to so I tell
> them try to use a flashback query.
>
> I ran the query and it returns the first portion 50% of the rows but
> then gives me an ORA-01555: snapshot too old: rollback segment number
> 121 with name "RBS204" too small.
> Is that due to the fact that her update or another transaction aged out
> the portion of the data that is giving this, or is due to the RBS204
> rollback seg not being large enough to give me all the data that is
> being returned?

Probably due to the requirement you use undo. See Metalink Note:143217.1
The undo_retention helps keep it around.

Since it partially works for you, maybe a really large RBS might have worked. Though by now
I'm sure you've restored. I'm surprised your compatible setting didn't give a "feature not enabled" error.

jg

--
@home.com is bogus.
'As I said, I fought against this effort and lost.  I even posted to
this group for arguements against it.  I got a number of replies, the
most to the point was Sybrand saying "You're going to Hell and you know
it." ' - Patrick Meyer