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: Automatic refresh of snapshot is failing

Re: Automatic refresh of snapshot is failing

From: Tom Best <tom.best_at_bentley.com>
Date: 10 Jul 2003 07:05:34 -0700
Message-ID: <c2da7c0a.0307100605.2bbfb2fd@posting.google.com> 





Take a look at the v$sql view and look for the sql that is being run
on behalf of the mv refresh (sql_text has the first several chars of
it).  Maybe you will see what the offending subselect in there and can
debug from that.



Tom Best
Received on Thu Jul 10 2003 - 09:05:34 CDT












Original text of this message













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