snapshot help

From: wluck <wluck_at_my-deja.com>
Date: Wed, 05 Jan 2000 04:51:03 GMT
Message-ID: <84uiji$5n7$1@nnrp1.deja.com>

Hi there. I've got this error message while creating a snapshot from the master table, tbl_1.

SQL> create snapshot s_seminar
2 as select * from seminar_at_ac_link;
as select * from seminar_at_ac_link

*
ERROR at line 2:
ORA-12014: table 'SEMINAR' does not contain a primary key constraint

In fact, i do have a PK for the master table. The link also seems to work as i'm able to select thru the link. Please help. Thanks.

I'm using oracle 8i for snapshot site and oracle 8.0.5 for master site.

Wei

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 04 2000 - 22:51:03 CST