_MLOG$ ? - how did it get created ?

[83]Hi Michel, Yeap.. Same exact version 11.2.0.4.8...... sze jie koh
[85]Hi Michel, In my example, the table are purge a...... sze jie koh
[86]I_MLOG is an index on mview log. Check hidden...... Michel Cadot
[87]Also checks the following points: - tablespace ...... Michel Cadot
[88]What about: <pre>select * from (select * from use...... Philip

Subject: I_MLOG$ ? - how did it get created ?
Os info: Linux64
Oracle info: 11gR2
Message: Hi all,
Running the following below in 2 different tablespace yield 2 different
results
create table test (a number primary key);
create materialized view log on test;

database A)
select object_name, object_type From user_objects where object_name like '%MLOG%
';
MLOG$_TEST TABLE
I_MLOG$_TEST INDEX

database B)
select object_name, object_type From user_objects where object_name like '%MLOG%
';
MLOG$_TEST TABLE

Notice there is no I_MLOG$_TEST -- why ?
Regards,
Noob


Subject: Re: I_MLOG$ ? - how did it get created ?
Message:
Same exact version (up to 4 decimals)? which one?
Regards
Michel


Subject: Re: I_MLOG$ ? - how did it get created ?
Message: Hi Michel,
Yeap.. Same exact version 11.2.0.4.8
Regards,
Noob


Subject: Re: I_MLOG$ ? - how did it get created ?
Message:
So maybe
1/ The mview logs were created in different versions before the
database/s was/were upgraded
2/ Someone has deleted the index in one database.
Regards
Michel


Subject: Re: I_MLOG$ ? - how did it get created ?
Message: Hi Michel,
In my example, the table are purge and recreated fresh.
drop table test purge;
create table test (a number primary key);
create materialized view log on test;
================================
This is done in both database.
But on 1, there is a I_MLOG, on another, there isn't..
By the way, is I_MLOG a mlog for an index on the master table ?
Regards,
Noob


Subject: Re: I_MLOG$ ? - how did it get created ?
Message:
I_MLOG is an index on mview log.
Check hidden and event parameters in both databases, especially in the
one that does not create the index.
Use OPatch to check if all patches are the same ones.
Regards
Michel


Subject: Re: I_MLOG$ ? - how did it get created ?
Message:
Also checks the following points:
- tablespace where is created the mview log
- default tablespace of table owner
- quota of owner on this default tablespace
Regards
Michel


Subject: Re: I_MLOG$ ? - how did it get created ?
Message: What about:
select * from (select * from user_objects order by created desc) o where rownum
< 5