Diff betwn Materrialized views
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Diff betwn Materrialized views

  1. #1
    Join Date
    Jan 2002
    Location
    India
    Posts
    105

    Diff betwn Materrialized views

    Dear Sir,

    1. I want to know exact differnce between
    Updatable Materialized view(MV) & writtable materialized views.

    2. Can you insert into Updatable MVs ?

    3. What is syntax for creating writtable MVs ????

    And why Oracle says that writtable MVs are very rare.
    I have typical requirements for this but I am worrying about any risk involved if at all any.

    viraj
    -------------
    9i OCA
    A Wise Man Knows How much he doesn't know !!!

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    What documentation did you read for discussion of writable MV and updatable MV?
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  3. #3
    Join Date
    Jan 2002
    Location
    India
    Posts
    105
    Dear sir

    Oracle Provided Documention name :Replication.dbf
    (I have downloaded this pdf ,few days back)

    My questions are very basic.

    I have tried out inserting into MV it does inserts but even afer refresh also it can not be viewed at Master site .

    AM I GOING CONCEPTUALLY WRONG ???
    A Wise Man Knows How much he doesn't know !!!

  4. #4
    Join Date
    Jan 2002
    Location
    India
    Posts
    105

    Reference

    This topic/subject comes under Oracle Advance Replication for your reference.

    Viraj
    -----------------------
    9i OCA
    A Wise Man Knows How much he doesn't know !!!

  5. #5
    Join Date
    Jan 2002
    Location
    India
    Posts
    105

    SOS

    dear sir ,

    Hey Where have all Oracle Expert in this site has gone ????
    Specialy Advisors

    Someone Reply for this question ???

    Viraj
    ------------
    9i OCA
    A Wise Man Knows How much he doesn't know !!!

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525

    Re: SOS

    Originally posted by virajvk
    dear sir ,

    Hey Where have all Oracle Expert in this site has gone ????
    Specialy Advisors

    Someone Reply for this question ???

    Viraj
    ------------
    9i OCA
    Yep! Thats the way to get your questions answered.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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