Oracle Database Discussions

In my star schema, many of my dimensions are IOT's. When I try to create fast-refreshed materialized views using them, I first encounter problems with the MV logs; I am unable to use WITH ROWID, only WITH PRIMARY KEY. However, when I run EXPLAIN_MVIEW, I get the message that the tables do not have "acceptable" primary keys. I have however spec'd the PK constraint in the table definition.

Are there incompatibilities with IOT's and Fast-Refresh? Are there any workarounds?

Thanks,

Scott Rappoport