Oracle database error code ORA-23414 – materialized view log for “string”.”string” does not record rowid values

Oracle Database Error Code ORA-23414 Description :
materialized view log for “string”.”string” does not record rowid values
Error Cause:
A rowid materialized view is being fast refreshed, but the materialized view log does not record rowid information.

How to Solve :
Use the CREATE MATERIALIZED VIEW LOG…ADD ROWID command to begin recording rowid information in the materialized view log.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»