Re: logical standby and funtion based indexes

Documentation Omission: Logical Standby Database Do Not Support Tables with Function-Based or Descending Indexes

As of Oracle9*i* Release 2, logical standby databases do not support tables with function-based or descending indexes. This information should have been included "Section 4.1.4 Determine Support for Datatypes or Tables" of the *Oracle Data Guard Concepts and Administration *(part number A96653-02) documentation.

There is no work-around for this problem in Oracle9*i* release 9.2. However, the restriction will be lifted in a future release. On 11g, this seems to be different:

http://docs.oracle.com/cd/E11882_01/server.112/e25608/create_ls.htm#i77026

Cheers -- Carlos

On Thu, Apr 5, 2012 at 7: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