For Meterialize view, when 'On demand' mode is used?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: For Meterialize view, when 'On demand' mode is used?

Hybrid View

  1. #1
    Join Date
    Mar 2000
    Location
    Toronto, Ontario, Canada
    Posts
    213
    Hi all,
    Can anybody shade a light on when 'ON DEMAND' refresh mode
    is used in materialized view?
    What is category in 'create OUTLINE...' syntax and why it is used?


    Thanks in Advance :)
    Regards,
    Vimal Patel
    OCP DBA 7.3, 8, 8i, 9i
    Sun Solaris 8 Sys. Admin.
    A+

  2. #2
    Join Date
    Mar 2000
    Location
    Toronto, Ontario, Canada
    Posts
    213

    Angry

    Hi all,
    still waiting for the response !!

    TIA,
    Regards,
    Vimal Patel
    OCP DBA 7.3, 8, 8i, 9i
    Sun Solaris 8 Sys. Admin.
    A+

  3. #3
    Join Date
    Mar 2000
    Location
    Toronto, Ontario, Canada
    Posts
    213
    Hi all,
    Still waiting for responses!!!

    Hope this time somebody will answer soon :)

    TIA,
    Regards,
    Vimal Patel
    OCP DBA 7.3, 8, 8i, 9i
    Sun Solaris 8 Sys. Admin.
    A+

  4. #4
    Join Date
    Mar 2000
    Location
    Toronto, Ontario, Canada
    Posts
    213

    Exclamation

    Hi,
    Waiting for reply!
    Regards,
    Vimal Patel
    OCP DBA 7.3, 8, 8i, 9i
    Sun Solaris 8 Sys. Admin.
    A+

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Vimal,

    It has been 4 days since you first posted this question. Although you've got no answer, 4 days must have been more than enough for you to search for oracle SQL Reference manual (either in printed form, on CD or on internet) and find an answer yourself! I would say that those questions you've posted are not realy that important for you as you obviously have not done anything to find an answer (appart for posting it 4 times in this forum)!

    And why you didn't get any answers? I'd say because you are asking such a broad questions that either:
    - answers are trivially easy to find in basic documentation, so nobody is willing to do this trivial search for you
    or
    - to answer such a question would demand to copy-paste an entire section or chapter from teh documentation, and again nobody find is very useful to do that here for you

    OK, I'll try to answer your questions...
    Q1) when 'ON DEMAND' refresh mode is used in materialized view?
    A1) Obviously when you don't want the MV to be refrereshed automaticaly, when you want to refresh them when *you* think is the right moment to.

    Q2) What is category in 'create OUTLINE...' syntax and why it is used?
    A2) I've never used outlines yet so I have no idea. But when I will need them I will surelly look at manuals first and find 99.99% answers to my questions there.

    No offence,

    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

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



Click Here to Expand Forum to Full Width