exp导出blob数据时报 ORA-22924: snapshot too old
针对该问题，参考
metalink Doc ID: 452341.1
Solution
1. Run the following script against the LOB tables in order to check for corruption:
set serverout on
exec dbms_output.enable(100000);
declare
pag number;
len number;
c varchar2(10);
charpp number := 8132/2;
begin
for r in (select rowid rid, dbms_lob.getlength () len
from) loop
if r.len is not null then
for page in 0..r.len/charpp loop
begin
select dbms_lob.substr (, 1, 1+ (page * charpp))
into c
from
where rowid = r.rid;
exception
when others then
dbms_output.put_line ('Error on rowid ' ||R.rid||' page '||page);
dbms_output.put_line (sqlerrm);
end;
end loop;
end if;
end loop;
end;
/
2. If two consecutive runs show the same rows, then it's a problem with those LOB records. The easiest way would be to delete the LOBs with mentioned ROWIDs and rebuild them (when possible)
[@more@]
metalink Doc ID: 452341.1
Solution
1. Run the following script against the LOB tables in order to check for corruption:
set serverout on
exec dbms_output.enable(100000);
declare
pag number;
len number;
c varchar2(10);
charpp number := 8132/2;
begin
for r in (select rowid rid, dbms_lob.getlength (
from
if r.len is not null then
for page in 0..r.len/charpp loop
begin
select dbms_lob.substr (
into c
from
where rowid = r.rid;
exception
when others then
dbms_output.put_line ('Error on rowid ' ||R.rid||' page '||page);
dbms_output.put_line (sqlerrm);
end;
end loop;
end if;
end loop;
end;
/
2. If two consecutive runs show the same rows, then it's a problem with those LOB records. The easiest way would be to delete the LOBs with mentioned ROWIDs and rebuild them (when possible)
[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/48010/viewspace-1019415/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
