Home » Server Options » Replication » Introduce index post replication (Oracle
Introduce index post replication [message #610483] Thu, 20 March 2014 09:41 Go to next message
Messages: 57
Registered: January 2011
Location: india

Apologies in advance if this is not the right forum for my query.
Please direct me to the right one if this isn't the right one.

My client is going to replicate their DB on to another environment with same environment parameters.

There is a DB table with close to a million rows in each table.
Each row has 27 columns.
The table already has a unique index of 20 columns.

Post replication the client wants to create 4 normal indexes each with one column.

In such a situation, what should be done post replication apart from just firing the CREATE INDEX command.

Please advise.

Re: Introduce index post replication [message #610492 is a reply to message #610483] Thu, 20 March 2014 11:25 Go to previous messageGo to next message
Michel Cadot
Messages: 67952
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator


Re: Introduce index post replication [message #610502 is a reply to message #610483] Thu, 20 March 2014 13:21 Go to previous message
John Watson
Messages: 8596
Registered: January 2010
Location: Global Village
Senior Member
A unique index on 20 of 27 columns is not sensible. Your client should consider re-creating the table as an IOT (possibly with an overflow segment).
Previous Topic: DDL synchronisation failed with error
Next Topic: MySQL to Oracle Replication using Goldengate
Goto Forum:

Current Time: Mon Sep 27 17:13:33 CDT 2021