Re: Creating unique index on huge table.

Thanks so much Franck and Tim for your suggestions. Vadim

On Thu, Sep 22, 2016 at 4:35 PM, Franck Pachot <franck_at_pachot.net> wrote:

> Ok so redo from index will be ignored by Dbvisit mine. No pb. If
> additional redo volume is a problem then you can consider nologging. Note
> that creating an index online generates more redo.
>
> Le jeu. 22 sept. 2016 à 16:32, Vadim Keylis <vkeylis2009_at_gmail.com> a
> écrit :
>
>> Hello Franck.
>> We are testing Dbvisit replicate application. The unique index that
>> I need to create would be on source database.
>>
>> Vadim
>>
>> On Thu, Sep 22, 2016 at 4:08 PM, Franck Pachot <franck_at_pachot.net> wrote:
>>
>>> 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