Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01555 on source database for materialized view refresh across link

Re: ORA-01555 on source database for materialized view refresh across link

From: Joel Garry <joel-garry_at_home.com>
Date: 27 Jan 2006 14:01:09 -0800
Message-ID: <1138399269.559994.38930@z14g2000cwz.googlegroups.com>


Oh yeah, O9 puts the ORA-1555 SQL in the alert log, although it misleadingly says it was caused by that SQL. It should say it was thrown by that SQL, the cause is usually something else (with the exception of Tom Kyte's commit example IIRC). My app sends too much SQL for the error to print though, so it's normally less than helpful by the time I see it in the alert log.

jg

--
@home.com is bogus.
Fight the net!  http://news.bbc.co.uk/2/hi/americas/4655196.stm
Received on Fri Jan 27 2006 - 16:01:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US