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

Chatta subito con l'assistenza

Ottieni assistenza in tempo reale
Completa la registrazione

Accedi

Richiedi prezzo

Contatta il supporto vendite

Restituisci

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Titolo

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

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.
Risoluzione

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 inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Request a KB Article

Contenuti consigliati

Prodotto/i:: SharePlex
11.0-11.3

Argomento/i:: Troubleshooting

Cronologia articoli:: Data di creazione: 2/21/2023
Ultimo aggiornamento: 7/31/2023

Cerca in tutti gli articoli

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

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

Titolo

Descrizione

Causa

Risoluzione

Leave a Comment