Tim,

I see two instances for my materialized view in the DBA_OBJECTS.

One with object_type as TABLE and another with 'UNDEFINED'.

But, I can still I am able to refresh the MV.

Questions:

1. Why there are two instances for the MV with the same name?

2. Why it shows 'UNDEFINED' in object_type?

Thanks,