用copy不行的。找了个pl/sql:
其中data表是原表,data字段是long型的
declare
cursor getdata
is select user_id,data from data;
getgetdata%rowtype;
--给变量get 定义
begin
--open getdata;
--if(:new.mobile=brec.user_id)then
insert into data_bak1(USER_ID,GUID,"type",MODIFIED_FLAG,TIME_STAMP,SEG1,"version",GROUP_ID)select USER_ID,GUID,"type",MODIFIED_FLAG,TIME_STAMP,SEG1,"version",GROUP_ID from data where user_id=:new.mobile;
--先copy除data外的数据。
loop
fetch getdata into get;
exit when getdata% notfound;
update data_bak1 set data=get.data where user_id=get.user_id;
end loop;
---再将data字段update至新表。
close getdata;
end if;
但执行时提示:
ORA-06502 ,有没有什么办法?
|