Re: Creating unique index on huge table.

From: Franck Pachot <franck_at_pachot.net>
Date: Thu, 22 Sep 2016 23:08:47 +0000
Message-ID: <CAK6ito0rqhMKZ8XbVEQjpH57ieJEW97R1_zGL-Tn+XEfCccquw_at_mail.gmail.com>

Hi,
Are you referring to Dbvisit standby or replicate? If replicate, do you create index on source or target?
Le jeu. 22 sept. 2016 à 14:44, Vadim Keylis <vkeylis2009_at_gmail.com> a écrit :

> I am working on adding replication using third party tool(dbvisit) to our
> databases.
>
> I have couple 5T highly transactional partition tables. I need to add a
> partition unique index to these tables without causing any outage or
> incurring performance hit. Will greatly appreciate suggestions on the best
> approach to do it.
>
> Thanks so much,
> Vadim
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 23 2016 - 01:08:47 CEST

This message: [ Message body ]
Next message: Vadim Keylis: "Re: Creating unique index on huge table."
Previous message: GG: "Re: listener proces owner by deamon user instead of grid"
Next in thread: Vadim Keylis: "Re: Creating unique index on huge table."
Reply: Vadim Keylis: "Re: Creating unique index on huge table."
Maybe reply: Tim Gorman: "Re: Creating unique index on huge table."
Maybe reply: Tim Gorman: "Re: Creating unique index on huge table."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message