Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Possibility to replicate an index

Re: Possibility to replicate an index

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 03 Dec 2005 17:17:38 +0100
Message-ID: <dmsfs1$k7n$5@news5.zwoll1.ov.home.nl>


Ralf Moosandl wrote:
> Dear all,
>
> anybody here who successfully replicated
> an non-primary-key to a materilized-view-site?
>
> Thanks in advance.
>
>

Indexes are NOT replicated (not using Advanced Replication, you'll have to check on Streams yourself).

What a non-primary-key has to do with it, I fail to see.

Just create an index on the MV.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Sat Dec 03 2005 - 10:17:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US