Alter of system generated index Post failing with ORA-01418: specified index does not exist. (4370306)

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

Alter of system generated index Post failing with ORA-01418: specified index does not exist.
Descrição

When Posting an alter statement to a system generated index, fails with ORA-01418: specified index does not exist.

Notice 2023-01-22 00:46:35.204619 30345 3489658624 s:2 Poster: ORA-01418: specified index does not exist (posting from o.splexrac, queue SPLEX, to o.splexrac) [module osp]
Error 2023-01-22 00:46:35.207329 30345 3489658624 s:2 Poster: [SP-OPO01002] Post process stopped due to DDL error ORA-01418: specified index does not exist on SQL alter index "schema"."SYS_C0041310" rebuild tablespace T.... <CAUSE> Post received a DDL error from the target database. Message:[subque/seq 2/1938 seqno/offset 11192/638240004]. <ADVICE> While Post is stopped, fix the problem so that this error does not occur again. Then, manually execute the correct DDL on the target and restart Post. (Note: On restart, Post will skip the original DDL that caused the error.) To configure Post to continue processing after it receives a DDL error, set the SP_OPO_STOP_ON_DDL_ERR parameter to 0 before starting Post. See 'http://advice.shareplex.com/SP-OPO01002' for additional advice and support. (posting from o.splexrac, queue SPLEX, to o.splexrac) [module opo]
Info 2023-01-22 00:46:35.332696 30310 2887940032 Poster exited with code=1, pid = 30345 (posting from o.splexrac, queue SPLEX, to o.splexrac)
Causa

When the system generated index is initially created on Source the name is generated by Oracle.
The create DDL statement is replicated to Target and the index is created under a different name generated by Oracle.
If the Source index is then altered, it is altered under the Source index name which is different to the Target index name, and hence the reason why Post cannot locate the index on Target.
Resolução

The system generated index will need to be manually altered on Target.
Restart Post to ignore the DDL error and to allow for posting to continue.

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
11.0-11.3

Tópico(s):: Troubleshooting

Histórico do artigo:: Criado em: 2/21/2023
Última atualização em: 7/31/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

Alter of system generated index Post failing with ORA-01418: specified index does not exist. (4370306)

Título

Descrição

Causa

Resolução

Leave a Comment