Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question re refreshing Materialized Views
>> WERE any of your questions actually relevant to my situation?
OK: keep digging, cool.
As an exmaple, how would your response to my situation differ had I said "9.0.1" as opposed to "9.2.0.8"?
Or if my DDL was "select * from mytable" as opposed to "[insert 500 lines of select query here: you choose the SQL, because I *really* don't think it's relevant]"?
And the explain path for both of those. How would that change your answer?
And this "change" that actually never occurred. Which change? There was no change. I never said anything changed. I said it was bung and it was being fixed by someone else, but it's been bung *from the outset*.
I take your point that generally "more info is better", and yes I should have said "9.2.0.1" and "9.2.0.6".
But the rest of what you continue to say is bullshit, right? Not that you should need to do otherwise, but you kinda skirted around my previous questions as to why your other questions had relevance to *my question* (not *in general*). Any answers?
I also note that the other respondents seemed to be able to answer the question without even *suggesting* they needed more info than that which I provided (except the 9i thing, that is).
I'm half being arsey at you because you seem to be being arsey to me... based on my bad wording in my response to you (sorry about that), so I probably deserved your slightly-fiery second response. And I'm half interested to know if there's actually any substance to what you're saying.
And the third half is just poking the animal in the cage with a stick.
-- AdamReceived on Thu Aug 16 2007 - 15:57:50 CDT