Replicate all the indexes of a Source Oracle

[Datateam]

Can you replicate all the indexes that a source Oracle database has to a destination Oracle database, not just the PKs?

I have an Oracle to Oracle replica and I want the Target database to have the same indexes as the Source.

It's possible?

[john_wang]

Hello @Datateam ,

Thanks for reaching out to Qlik Community!

In general Qlik Replicate only replicate the below source side index information to target side:

1- If the table has PK, then PK will be replicated (all other Unique Index and regular index will not being replicated);

2- If the table has no PK but has one Unique Index then the UI will be replicated (all other regular index will not being replicated);

3- If the table has multiple UI then the first UI (order by name) will be replicated;

4- If the table has NO PK nor UI then no index metadata information will be replicated.

Certainly you may choose different column(s) as target table PK in transformation however there are some limitations.

Regarding your question: No, Replicate does not replicate all index information. You can do that by Oracle SQL or tools, eg Oracle data pump, and dblink etc.

Hope this helps.

John.