Re: Newbie question re refreshing Materialized Views

On Thu, 16 Aug 2007 21:57:50 +0100, Adam Cameron <adam_junk_at_hotmail.com> wrote:

>>> WERE any of your questions actually relevant to my situation?
>>
>> Yes: All of them. Things in Oracle change from version to version.
>> Correct answers for almost everything require exact version info.
>
>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.

What are you trying to accomplish?
You want help. So why do you just don't answer his justified questions?
Why posting all this bullshit?
Apparently you seem to 'know' the answer. You are getting answers which don't suit you. In the meantime you are establishing yourself as a person who would best be killfiled right away, just because of your attitude.
As to you version questions:
9.0.1 is desupported. Period.
9.2 is desupported. If you aren't on 9.2.0.8, you don't qualify for extended support, you go to sustaining support right away. Did you ever read release notes? Probably not. Are you aware how many issues, *including MV issues* have been resolved between 9.2.0.1 and 9.2.0.8?
You are undeservedly flaming Daniel Morgan, and a bit of modesty would reallly suit you, 'Sir'

-- 
Sybrand Bakker
Senior Oracle DBA