ORA-32408: materialized view log on "string"."string" already has new values
Cause: The materialized view log on the indicated table already has new values
Action: No action required
https://support.oracle.com/
http://www.oracle.com/
Category Archives: ORA Database Error Messages
ORA-32407: cannot exclude new values when materialized view log includes new values
ORA-32407: cannot exclude new values when materialized view log includes new values
Cause: The excluding new values specification for the existing materialized view log cannot be accepted when including new values is the current option
Action: change excluding new values clause
ORA-32406: cannot alter partitioning for existing materialized view log
ORA-32406: cannot alter partitioning for existing materialized view log
Cause: The partitioning specification for the existing materialized view log cannot be altered or changed
Action: remove the partitioning clause from the statement
ORA-32405: cannot alter tablespace for existing materialized view log
ORA-32405: cannot alter tablespace for existing materialized view log
Cause: The tablespace specification for the existing materialized view log cannot be altered or changed
Action: remove the tablespace clause from the statement
ORA-32404: snapshot log uses Change Data Capture which is not enabled for this database
ORA-32404: snapshot log uses Change Data Capture which is not enabled for this database
Cause: A snapshot log that utilizes Change Data Capture is being imported to a database where Change Data Capture has not been enabled
Action: First enable Change Data Capture on the database then retry the import
ORA-32403: cannot use new values from mv log on “string”.”string”
ORA-32403: cannot use new values from mv log on "string"."string"
Cause: The materialized view log either does not have new values logged, or the timestamp associated with the new values columns is more recent than the last refresh time
Action: Perform a complete refresh is required before the next fast refresh
ORA-32401: materialized view log on “string”.”string” does not have new values
ORA-32401: materialized view log on "string"."string" does not have new values
Cause: Materialized view log on the indicated table does not have new values information
Action: Add new values to materialized view log using the ALTER MATERIALIZED VIEW LOG command
ORA-32400: cannot use object id columns from materialized view log on “string”.”string”
ORA-32400: cannot use object id columns from materialized view log on "string"."string"
Cause: The materialized view log either does not have object id columns logged, or the timestamp associated with the object id columns is more recent than the last refresh time
Action: A complete refresh is required before the next fast refresh. Add object id columns to the materialized view log, if required
ORA-32345: fail to refresh the materialized view string.string due to the changed synonym
ORA-32345: fail to refresh the materialized view string.string due to the changed synonym
Cause: The definition of one or more synonyms in the from clause have changed. The structure of the materialized view has become invalid
Action: Restore the synonym(s) or drop the materialized view and recreate it again
ORA-32344: cannot create a secondary materialized view with synonym as base table
ORA-32344: cannot create a secondary materialized view with synonym as base table
Cause: It is not supported to create a secondary materialized view with synonym in the FROM clause
Action: Removed the synonym(s) from the statement