ORA-32406: cannot alter partitioning for existing
materialized view log



ORA-32406: cannot alter partitioning for existing materialized view log..

Answer / guest

Cause: The partitioning specification for the existing
materialized view log cannot be altered or changed.

Action: remove the partitioning clause from the statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32135: Cannot assign FILEs

1 Answers  


ORA-25192: invalid option for an index-organized table

1 Answers  


QSM-02090: SELECT includes an expression that is not just a column

1 Answers  


QSM-02050: subquery using the ALL clause in mv

1 Answers  


when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

0 Answers  






ORA-06801: TLI Driver: listen for SPX server reconnect failed

1 Answers  


ORA-29514: class name contains illegal character

1 Answers  


ORA-23400: invalid materialized view name "string"

1 Answers  


ORA-00821: Specified value of sga_target is too small, needs to be at least stringM

1 Answers  


ORA-24158: invalid table alias

1 Answers  


ORA-12686: Invalid command specified for a service

1 Answers  


ORA-07503: scgcmn: $setimr unexpected return

1 Answers  


Categories