目标库上执行:
迁移过程带lob字段的T_EC_EVENT表特别慢,停机时间太长,通过物化视图提前迁移T_EC_EVENT表。
含lob字段大表通过dblink,创建物化视图(不停机)
SQL> create materialized view T_EC_EVENT on prebuilt table refresh fast as select * from T_EC_EVENT@his_lk;
完全刷新
exec dbms_mview.refresh('T_EC_EVENT','COMPLETE',PARALLELISM=>8);
SQL> exec dbms_mview.refresh('T_EC_EVENT','COMPLETE',PARALLELISM=>8);
PL/SQL procedure successfully completed.
SQL>
SQL> select count(*) from t_ec_event;
COUNT(*)
----------
3909401
增量刷新(多次)
SQL> exec dbms_mview.refresh('T_EC_EVENT');
exec dbms_mview.refresh('T_EC_EVENT','FAST',PARALLELISM=>1);
最后一次增量,删除物化视图(停业务)
Drop materialized view T_EC_EVENT;
修改sequences与主库保持一致
图略
修改约束
alter table t_ec_event modify eventcontent not null;
排除大表,导入:
impdp \'/ as sysdba\' network_link=his_lk exclude=table:"in('T_EC_EVENT')" schemas=cuteinfo remap_schema=cuteinfo:cuteinfo