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

Tchater maintenant avec le support

Obtenir une aide instantanée
Terminer l’enregistrement

Se connecter

Demander les tarifs

Contacter le service des ventes

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

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

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)
Cause

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.
Résolution

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.

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Demander un article de la base de connaissances

Contenu recommandé

Produit(s) :: SharePlex
11.0-11.3

Sujet(s) :: Troubleshooting

Historique de l’article :: Créé le : 2/21/2023
Dernière mise à jour le : 7/31/2023

Rechercher tous les articles

Veuillez sélectionner votre produit

Afin de mieux répondre à vos besoins, précisez l'objet du tchat:

Solutions recommandées pour votre problème

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

Titre

Description

Cause

Résolution

Leave a Comment