ORA-12030: cannot create a fast refresh materialized view
Cause: The materialized view log did not exist or did not log the information needed by the materialized view to perform a fast refresh.
Action: Ensure that the materialized view log exists and logs the necessary information. - For ROWID materialized views, the master table s ROWID must be logged. - For primary key materialized views, the master table s primary key columns must be logged. values must be logged.
Cause: The materialized view log did not exist or did not log the information needed by the materialized view to perform a fast refresh.
Action: Ensure that the materialized view log exists and logs the necessary information. - For ROWID materialized views, the master table s ROWID must be logged. - For primary key materialized views, the master table s primary key columns must be logged. values must be logged.
No comments:
Post a Comment