Re: logical standby and funtion based indexes
- From: Carlos Sierra <carlos.sierra.usa@xxxxxxxxx>
- To: eglewis71@xxxxxxxxx
- Date: Fri, 6 Apr 2012 07:23:25 -0400
Ed,
From 259804.1:
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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
