+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 18
  1. 08-22-2003 02:44 PM #1
    balajiyes
    balajiyes is offline Advisor
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    Unhappy Analytical Function in MV

    Hi All,

    Can we use Analytical functions like lead, lag, etc. in FAST REFRESH Materialized Views???

    Thnx in Advance

    Cheers!
    Reply With Quote Reply With Quote
  2. 08-25-2003 04:23 PM #2
    kanna
    kanna is offline Junior Member
    Join Date
    Jun 2003
    Location
    India
    Posts
    24
    I think u can't use analytical function while creating materialized view with refresh fast option..

    Wow!
    Luv
    Kanna
    Reply With Quote Reply With Quote
  3. 08-26-2003 04:22 AM #3
    TomazZ
    TomazZ is offline Junior Member
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    RTFM
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
    Reply With Quote Reply With Quote
  4. 08-26-2003 09:47 AM #4
    kanna
    kanna is offline Junior Member
    Join Date
    Jun 2003
    Location
    India
    Posts
    24
    Hi Tomazz,

    May i know why have u given this link?
    Luv
    Kanna
    Reply With Quote Reply With Quote
  5. 08-26-2003 09:57 AM #5
    TomazZ
    TomazZ is offline Junior Member
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    To support your opinion with documentation...
    why?
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
    Reply With Quote Reply With Quote
  6. 08-26-2003 10:13 AM #6
    kanna
    kanna is offline Junior Member
    Join Date
    Jun 2003
    Location
    India
    Posts
    24
    Hi Tomazz,

    Simple question.. Can we use lag function while creating materialized view with fast refresh option?
    Luv
    Kanna
    Reply With Quote Reply With Quote
  7. 08-26-2003 10:58 AM #7
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Tomaz already gave you the simple answer. Did you read the link he posted?

    "Materialized views are not eligible for fast refresh if the defining query contains an analytic function."
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
  8. 08-26-2003 01:10 PM #8
    kanna
    kanna is offline Junior Member
    Join Date
    Jun 2003
    Location
    India
    Posts
    24
    Hi Tomazz,

    Simple question.. Can we use lag function while creating materialized view with fast refresh option?
    Luv
    Kanna
    Reply With Quote Reply With Quote
  9. 08-26-2003 02:38 PM #9
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    huh? are you reading the replies
    Reply With Quote Reply With Quote
  10. 08-26-2003 02:48 PM #10
    balajiyes
    balajiyes is offline Advisor
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    Thnx for ur help guys...

    No Luck still on fast refresh..... :(

    Cheers!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules

 Click Here to Expand Forum to Full Width