Re: Question about read-only snapshot

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 30 Oct 2002 21:59:26 -0000
Message-ID: <3dc05a21$2_3@mk-nntp-1.news.uk.worldonline.com>

"Carlos Alberto" <calberto2312_at_hotmail.com> wrote in message news:72954535.0210300624.1fc2b6c8_at_posting.google.com...
> Hi,
>
> I setup some read-only snapshots in my database, and I´m using
> replication with primary key option. I have a question about it :
>
> Do I need to create primary keys on all tables that use fast refresh?
> If the table doesn´t have a PK, the only option is to use complete
> refresh?
>
> I´m using Oracle 8.1.7.
>
> Thanks in advanced,
> Carlos

Carlos,

Before we discuss replication, can you explain why any table doesn't have a primary key?

Paul Received on Wed Oct 30 2002 - 15:59:26 CST