3,491
社区成员
发帖
与我相关
我的任务
分享
----大概写了下,不过还是建议使用exp/imp
create or replace procedure sysnfrom2db(fromtable in varchar2,
totable in varchar2,
o_ret out number,
o_msg out varchar2) as
v_dsql varchar2(1000);
v_isql varchar2(1000);
begin
v_dsql := 'truncate table ' || totable;
v_isql := 'insert into ' || totable || ' select * from ' || fromtable ||
'@dblinkname';
execute immediate v_dsql;
execute immediate v_isql;
commit;
exception
when others then
rollback;
o_ret := sqlcode;
o_msg := sqlerrm(sqlcode);
end;