你讲的是高级复制的物化视图吧。
把你两边的sequence设置不同的范围
例如:
A:
create sequence XXX increment by 1 start with 1 maxvalue 44 cycle nocache;
B:
create sequence XXX increment by 1 start with 45 maxvalue 99 cycle nocache;
把你两边的sequence设置不同的范围
例如:
A:
create sequence XXX increment by 1 start with 1 maxvalue 44 cycle nocache;
B:
create sequence XXX increment by 1 start with 45 maxvalue 99 cycle nocache;
create sequence s_aa01
minvalue 1
maxvalue 99999999999999
start with 99999999999999
increment by -1(可以么?)
nocache;以后 会不会出想什么问题?