文档解释
ORA-08194: Flashback Table operation is not allowed on materialized views
Cause: An attempt was made to perform Flashback Table operation on a materialized view. This is not permitted.
Action: Do not perform a Flashback Table operation on materialized views or snapshot logs.
官方解释
ORA-08194:禁止在材料视图上执行回滚表操作。
常见案例
一个使用Flashback Table操作试图对materialized view进行操作时,可能发生此错误。
正常处理方法及步骤
解决此问题的方法是不要在materialized view上执行Flashback Table操作。若要回滚数据,则可以使用Flashback Database操作。