Post error "failed to commit transaction session 13 in CommitFunc(): ORA-23413' (4301866)

サポートと今すぐチャット

戻る

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

タイトル

Post error "failed to commit transaction session 13 in CommitFunc(): ORA-23413'
説明

Event_log shows the below error:
Info 2016-02-23 10:11:46.029207 13966 2456524624 Poster exited with code=1, pid = 20831 (posting from SID1, queue queue_name, to SID2)
Error 2016-02-23 10:11:45.986773 20831 3272325440 s:13 Poster: failed to commit transaction session 13 in CommitFunc(): ORA-23413: table "OWNER"."TABLE_NAME" does not have a materialized view log. Will exit Post.. (posting from SID1, queue queue_name, to SID2) [module opo]
event_log (15/55)
原因

The master table does not have a materialized view log associated with it.
対策

Resolution:
1. Stop Post
2. Create materialized view log on the master table whose name appears in the error
3. Start Post
追加情報

Here is the description of the ORA-23413 ORA-23413: table "string"."string" does not have a materialized view log Cause: The fast refresh can not be performed because the master table does not contain a materialized view log. Action: Use the CREATE MATERIALIZED VIEW LOG command to create a materialized view log on the master table.

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

推奨コンテンツ

タイトル