Oracle DBA, How To, Error, Cause and Action

ORA-16311: materialized view log already exists

ORA-16311: materialized view log already exists


Cause:


A call was made to DBMS_LOGSTDBY.EDS_ADD_TABLE for a table with a LOB that requires the creation of a specifically-defined materialized view log but one already exists.



Action:


Drop the existing materialized view log and retry the operation.

No comments:

Post a Comment

Thanks for your comment.