rupd$ in materialized view logs

[jennifer2007]

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

[reydp]

delete it, it means trouble.

[jennifer2007]

what? are u kidding papa rey...why the trouble

[reydp]

that means, it shouldn't be there. Only the MLOG$_.

[davey23uk]

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

[reydp]

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.

[davey23uk]

stop giving bad and wrong advice and you will stop getting called on it

[jennifer2007]

cool dear

[reydp]

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.


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

[Bore]

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