Re: Snapshots between Oracle 8's

From: Shi yousong <yousong_at_bigpond.com>
Date: Tue, 05 Oct 1999 12:07:43 +1000
Message-ID: <37F95D6F.47B10C33@bigpond.com>

Hi ,

Actually nothing is wrong except the master table needs a primary key to do the replication job. So create it on the master table before you create the snapshot on snapshot site. This is required by oracle replication.

regards,

Sam

Steven Crimmins wrote:

> Hi,
> I am trying to create snapshot from one Oracle 8 to another. When I
> attempt to create it I receive the following error message:
>
> ORA-12014: table 'MEMBER' does not contain a primary key constraint
>
> The table on the remote Oracle is called member. I can perform the
> select to the remote database ie select * from member_at_remotedb and get
> the results fine.
>
> Can anybody tell me what I may be doing wrong?
>
> Thanks
> Steve
Received on Mon Oct 04 1999 - 21:07:43 CDT