ORA-32313: REFRESH FAST of "string"."string" unsupported
after PMOPs



ORA-32313: REFRESH FAST of "string"."string" unsupported after PMOPs..

Answer / guest

Cause: A Partition Maintenance Operation (PMOP) has been
performed on a detail table, and the specified materialized
view does not support fast refersh after PMOPs.

Action: Use REFRESH COMPLETE. Note: you can determine why
your materialized view does not support fast refresh after
PMOPs using the DBMS_MVIEW.EXPLAIN_MVIEW() API.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07290: sksagdi: specified directory for archiving does not exist.

1 Answers  


ORA-25330: PL/SQL associative arrays may not be used with AQ array operations

1 Answers  


ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

1 Answers  


TNS-00270: %s: Terminal Error string

1 Answers  


ORA-09241: smsalo: error allocating SGA memory

1 Answers  


NZE-28813: invalid record type

1 Answers  


NNL-00578: dump_ldap: dump addresses in the domain or region to LDAP

1 Answers  


RMAN-08519: channel string: scanning datafilecopy string

1 Answers  


PLS-00602: CUBE and ROLLUP may appear only in a GROUP BY clause

1 Answers  


ORA-32736: Hang analysis aborted due to wrong message type

1 Answers  


PLS-00725: type 'string' must be a supertype or subtype of the TREAT expression

1 Answers  


IMG-00583: output format does not support the specified compressionFormat

1 Answers  


Categories