Re: logical standby and funtion based indexes

Active DG should work as it would be using a physical standby thus eliminating the FBI restriction. That said, Streams might be another (cheaper) option to consider. I can't personally attest to it working with FBIs, but as per the documentation, as of 10.2, it supports them: http://docs.oracle.com/cd/B19306_01/server.102/b14229/whatsnew.htm#i972920

On Thu, Apr 5, 2012 at 4:17 PM, ed lewis <eglewis71_at_gmail.com> wrote:
> Hello,
>    We've created a logical standby, and discovered
> issues with tables that have function-based indexes.
> Its appear the LSB does not use them. This caused
> the LSB to lag far behind the primary database.
> This particular DB has over a thousand tables with
> FBIs.
>    To resolve this, we're adding unique indexes to the
> offending tables that require them. To me, this is not
> an ideal solution, especially as table volumes grow.
>
>    I'm considering implementing active dataguard, and use this
> as our reporting DB. I hope to be able to try this in a week
> or so.
>
>    Hasn't anyone used active dg to resolve the FBI issue ?
>
>    Does anyone have any other solutions ?
>
>    Your feedback is appreciated.
>
> thanks
>        ed lewis
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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