Errors “Poster 12070 - OCITransCommit failed with ORA-12008” and “error in materialized view refresh path.ORA-00942 table or view does not exist” (4302327)

Converse agora com nosso suporte

Obtenha ajuda em tempo real
Concluir registro

Entrar

Solicitar preços

Entre em contato com o setor de vendas

Voltar

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Título

Errors “Poster 12070 - OCITransCommit failed with ORA-12008” and “error in materialized view refresh path.ORA-00942 table or view does not exist”
Descrição

The following errors are seen in target event_log when a materialized view exists on target where the underlying table may or may not be a part of replication:
Error    2016-01-21 22:27:03.638086 20880 1365956928 s:2 Poster: 12070 - OCITransCommit failed with ORA-12008. (posting from SID1, queue queue_name, to SID2) [module osp]
Error    2016-01-21 22:27:03.644732 20880 1365956928 s:2 Poster: failed to commit transaction session 2 in CommitFunc(): ORA-12008: error in materialized view refresh path.ORA-00942: table or view does not exist. Will exit Post.. (posting from SID1, queue queue_name, to SID2) [module opo]
Info     2016-01-21 22:27:03.665129 16418 3646488288 Poster exited with code=1, pid = 20880 (posting from SID1, queue queue_name, to SID2)
Causa

The refresh activities on materialized view on target are interfering with Post.
Resolução

Most common reason for seeing the ORA-12008 and ORA-00942 during materialized view refresh is that the underlying target table(s) have been dropped. Recreate those tables while ensuring that the materialized view owner has the requisite grant on these, and then drop and recreate the materialized view and materialized view logs on the target. Then restart Post. This will result in Post running normally. Shareplex do replicate from materialized view to a table and the materialized view can exist on target. But if it is interfering with Post, these steps will help resolve the error.
Another reason for seeing ORA-00942 is that though the underlying tables may exist, the owner of materialized view lacks the privileges on the tables that comprise the materialized view. So it results in ORA-00942. This usually happens when the underlying tables are dropped and recreated, the grants have not been run on the newly created tables. Grant the requisite privileges on the newly created tables forming part of materialized view and restart Post.
Informações adicionais

For privileges associated with materialized view, please refer to Oracle documentation as it is a wide subject and its treatment is beyond the scope of this article.

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Solicitar um artigo da base de conhecimento

Conteúdo recomendado

Produto(s):: SharePlex
7.6.3

Tópico(s):: Troubleshooting

Histórico do artigo:: Criado em: 1/21/2016
Última atualização em: 5/7/2023

Search All Articles

Selecione seu produto:

Para podermos atendê-lo melhor, informe o Propósito de seu chat:

Soluções recomendadas para seu problema

Errors “Poster 12070 - OCITransCommit failed with ORA-12008” and “error in materialized view refresh path.ORA-00942 table or view does not exist” (4302327)

Título

Descrição

Causa

Resolução

Informações adicionais

Leave a Comment