rupd$ in materialized view logs
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 26

Thread: rupd$ in materialized view logs

  1. #1
    Join Date
    Feb 2007
    Posts
    212

    rupd$ in materialized view logs

    Dear Friends,

    I created a materialized view log on on EMP. And It created me two tables
    which are (MLOG$_EMP and RUPD$_EMP).
    Whats the purpose of this RUPD$_EMP pls?

    Thanks

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    delete it, it means trouble.
    ---------------

  3. #3
    Join Date
    Feb 2007
    Posts
    212
    what? are u kidding papa rey...why the trouble

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    that means, it shouldn't be there. Only the MLOG$_.
    ---------------

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    why on earth do you say that????? what a stupid answer

    rupd$ tables are there when the mv log tables have primary keys and it supports updateable mv's which can only be done on log tables with pk's

  6. #6
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    you really is a trigger happy Davey when it comes to negative remarks..

    Actually, It just popup into my mind 'coz I remember it once when I encounter an error like "ORA-995" or "ORA-955".

    So if Jen didn't encounter any problem then be happy with your life.

    That's why I mentioned "trouble", 'coz that's what I remember. I'm not into MVs lately, and yet I don't excuse myself.

    You don't need to do that Davey coz I never give that kind of remarks when you're on the other side.
    ---------------

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    stop giving bad and wrong advice and you will stop getting called on it

  8. #8
    Join Date
    Feb 2007
    Posts
    212
    cool dear

  9. #9
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Quote Originally Posted by davey23uk
    stop giving bad and wrong advice and you will stop getting called on it

    So the Mr. Perfect/Non-Rubbish Guy has really this role here.

    Scan the below docs, just to give you an idea what I meant.
    I just search this document for this purpose alone.
    --------------------------------------------------------
    DB PROPOGATE PROBLEM WITH SNAPSHOTS ORA-955
    Doc ID: Note:251410.1 Type: PROBLEM
    Last Revision Date: 04-AUG-2004 Status: PUBLISHED


    The information in this article applies to:

    affected Oracle Products:

    oracle rdbms 8.1.7 - 9.2.
    db propagate 9.2



    Symptom(s)
    ~~~~~~~~~~

    Db propagate of a schema containing materialized view logs (snapshot logs)
    will result in "ORA-00955: name is already used by an existing object"
    on a object with name RUPD$_.

    This error will always happen, if db propagate contains the objects:
    the snapshot log itself,the table the snapshot log is based on and the table
    RUPD$_.

    Cause
    ~~~~~~~

    Creating one single snaphsot log on a existing table (containing a index)
    will create three objects:
    the snapshot log: MLOG$_
    table: MLOG$_
    tbale: RUPD$_

    DB propagate suppresses the table MLOG$_ but not the
    table RUPD$_.
    The db propagte script execution will first create the snapshot log and then
    create the table RUPD$_, but the table is already -indirect- created
    by the creation of the snapshot log and so a ORA-955 will be displayed.


    Fix
    ~~~~

    Remove the table RUPD$_ from the db propagation.


    ------------------------------------------------------------
    ---------------

  10. #10
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    I would not drop anything created by Oracle, if I am not advised to do so by the Oracle Support or if I am not completely sure what this object is ment for, and that Oracle could function properly without it ( to be honest I do not remember such case, when Oracle creates something useless)
    So, Jenny, it's up to you :-)

    Regards

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