ORA-23413 错误信息是 "table does not have a materialized view log on it",意思是在尝试对一个表执行与物化视图(Materialized View)相关的操作时,该表上没有创建相应的物化视图日志(Materialized View Log)。 2. ORA-23413 错误可能出现的场景 ORA-23413 错误通常出现在以下
DROP materialized view log on TAB_NAME ; --不是view名,是表名 CREATE MATERIALIZED VIEW LOG ON TAB_NAME WITH ROWID;
oracle 物化视图 ORA-23413: 表 DROP materialized view log on TAB_NAME ; --不是view名,是表名 CREATE MATERIALIZED VIEW LOG ON TAB_NAME WITH ROWID;
Your Intial or Incremental Sales Request Set Program completes with the following error:ORA-23413: table "APPS"."<materialized_view>_MV" does not have a materialized view logFor example:ORA-23413: table "APPS"."BIL_BI_OP12_PG_MV" does not have a materialized view logCause...
oracle 物化视图 ORA-23413: 表 "xxx"."xx" 不带实体化视图日志 DROP materialized view log on TAB_NAME ; --不是view名,是表名 CREATE MATERIALIZED VIEW LOG ON TAB_NAME WITH ROWID;