建立快照时出错

[hellobb]

dblink已建，且
select * from TBTYPE@j63可返回远程数据库中TBTYPE的值，
但执行：
Create snapshot j_snap as Select idtype,sname From TBTYPE@j63;
时提示：
ORA-12014: 表'TBTYPE'不包含主关键字约束条件.
这是什么意思，写法有什么问题吗

[dongxiangjun]

Create snapshot j_snap
with rowid
as Select idtype,sname From TBTYPE@j63;

[hellobb]

还是不行，提示：缺少关键字。能解释一下吗

[black_snail]

Oracle Product Document Library (C) Oracle Corporation
Manual: ORACLE 8.1.7 SERVER CODES Reference: A


ORA-12014 table 'string' does not contain a primary key constraint

Cause: The CREATE SNAPSHOT LOG command was issued with the WITH PRIMARY KEY option and the master table does not contain a primary key constraint or the constraint is disabled.

Action: Reissue the command using only the WITH ROWID option, create a primary key constraint on the master table, or enable an existing primary key constraint.

[black_snail]

You must have your master table with a Primary Key!(or use Rowid)