WebFocus and Oracle Views

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 5 Jan 2011 07:29:14 -0500

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: