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

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

.

Relevant Pages

  • Re: Oracle 11g placement of the alert log
    ... alert log will go back to where it was. ... Oracle Ace Director & Instructor ... SQL> show parameter background_dump_dest ... the "traditional" alert log file is updated in less then timely manner. ...
    (comp.databases.oracle.server)
  • Re: Oracle 11g placement of the alert log
    ... alert log will go back to where it was. ... Oracle Ace Director & Instructor ... SQL> show parameter background_dump_dest ... Database mounted. ...
    (comp.databases.oracle.server)
  • Re: end-of-file on communication channel
    ... One of the DBA's came up witha work araound of altering the sql as ... FROM alpha mp, alpha cp, ... Were any trace files produced when you got the error? ... alert log when the client experiences the "end of file communication"? ...
    (comp.databases.oracle.server)
  • Re: who can tell me why
    ... head, maybe you're writing a class which does SQL stuff, and puts things into collections. ...
    (comp.lang.java.programmer)
  • Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
    ... I might argue that .Refresh should've thrown an exception, ... in the SQL Server MVP group in which I posted this ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)