This content has been marked as final. Show 3 replies
Please provide full version information and either the DDL for the MV or at least enough information for us to know what type you are trying to create.
Oracle 10g (10.2.0.2.0) is the version:
CREATE MATERIALIZED VIEW LOG on DD_TABLENAME;
CREATE MATERIALIZED VIEW DD_TABLENAME_VIEW REFRESH FAST WITH PRIMARY KEY AS SELECT * FROM DD_TABLENAME@DMRMET WHERE STATUS = '3';
I'm a moron, none of the status codes had been changed to 3 yet... didn't realize it until I pasted it here...