Re: WebFocus and Oracle Views

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: Richard.Goulet@xxxxxxxxxxx
  • Date: Wed, 5 Jan 2011 12:49:04 +0000

I've never heard of it, but a dev tool that *required* database constructs
that were resource intensive and out of date would be banned when I became
King. What does his change control document say, and who approves it? If you
really , really can't talk sense into him then you sometimes have to let
people hang themselves in a properly documented fashion.

On 5 Jan 2011 12:37, "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx> wrote:

 Guys and Gals,

        I've a WebFocus developer here who is telling mew that he cannot use
a view to query data from the database.  The app developers have created and
tuned these views to the n'th degree so that they provide correct data
quickly ( I have to pat these folks on the back as they really did work hard
on them).  Anyway this duhveloper wants to create MV's out of them so that
"WebFocus will behave as expected" and he is absolutely adamant about it to
the point that he has not started his work because "we won't let him create
his MV's".  BTW: he wants to refresh these at 1 minute intervals and they
will require a full refresh.  I've searched the WEB and even talked to a
couple of others that I know who've used WebFocus and can't find anything
that in any way substantiates what this person is telling me.  In a bit of
frustration with him I'm turning to the list to see if any of you have ever
heard or seen anything along these lines.  All replies are appreciated.  As
I understand it it's WebFocus 7.0 on Linux RH5 using an Oracle 11.1.0.7
backend database also on RH.

        Thanks in advance.

Dick Goulet
Senior Oracle DBA

Other related posts: