Error while creating materialized view with refresh complete option and the table for which the view has to be created does not contain any primary keys then an error will be thrown while creating the view.
ORA-12014: 'XXX.CUSTOM_TABLE' does not contain any primary key constraint.
Solution - Create view with ROW ID option should be used with the refresh option
No comments:
Post a Comment