【摘要】 Oracle要求实现复制的数据库对象必须有主键。当进行多台数据库之间的同步复制时,如果有一些表没有主键,并且表中存在相同的记录,就需要增加一个标识字段作为主键。提出了一种运用Oracle中的序列、触发器、视图的解决方法,可以使软件系统中的代码不用作任何修改。更多还原

【Abstract】 Database object must have primary key in Oracle’s replication.In synchronous replication of several databases,if there are several tables which don’t have primary keys and have the same records,then the DBA need to add a column to be the primary key.This paper offers a method which uses the sequence,trigger and view in Oracle.And the program needn’t to be changed at all.更多还原