RE: WebFocus and Oracle Views
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- Date: Wed, 5 Jan 2011 07:54:19 -0500
Hi Niall,
We're not into the change control on this yet as it's new
development. And talking sense to this particular individual is better
done to the wall. Listens better, talks back less.
Dick Goulet
Senior Oracle DBA
________________________________
From: Niall Litchfield [mailto:niall.litchfield@xxxxxxxxx]
Sent: Wednesday, January 05, 2011 7:49 AM
To: Goulet, Richard
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: WebFocus and Oracle Views
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:
