hi all,

Following is the query and the error which occurs


SELECT customer_number as customernumber
from cdtcard
where customer_number in(select customer_number as customernumber
from cdtpersn
where customer_number in(SELECT customer_number
from cdtaduse
where address_key in(SELECT
address_key

from cdtaddr

where postcode like 'DE%' ))
AND gender like 'F' AND title like 'MISS' AND surname like 'Long%' )
AND SCHEME_IDENTIFIER = 1, null)


Failed: ORA-01555: snapshot too old: rollback segment number 2 with name
"_SYSSMU2$" too small.

Please help me out as this is very urgent


Whilst this email has been checked for all known viruses, recipients should undertake their own virus checking as Xansa will not accept any liability whatsoever.

This email and any files transmitted with it are confidential and protected by client privilege. It is solely for the use of the intended recipient.
Please delete it and notify the sender if you have received it in
error. Unauthorised use is prohibited.

Any opinions expressed in this email are those of the individual and not
necessarily the organisation.
Xansa, Registered Office: 420 Thames Valley Park Drive,
Thames Valley Park, Reading, RG6 1PU, UK.
Registered in England No.1000954.
t +44 (0)8702 416181
w www.xansa.com

Oracle LazyDBA home page