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部落格 ” ,連結:http://blog.itpub.net/48010/viewspace-1019415/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-01555: snapshot too old: rollback segment number with name "" too small
- 資料匯入匯出EXP/IMP
- exp/imp匯出匯入資料
- oracle資料匯出匯入(exp/imp)Oracle
- 【效能優化】處理ORA-01555:Snapshot Too Old優化
- ORA-01555: snapshot too old的分析與解決
- Oracle資料匯入匯出imp/exp命令Oracle
- oracle資料的匯入匯出imp/expOracle
- Oracle exp只匯出部分資料Oracle
- 0225Snapshot Too Old Error ora-01555.txtError
- Oracle資料匯入匯出imp/exp命令(轉)Oracle
- 轉oracle資料泵匯出時報錯Oracle
- Oracle資料庫匯入匯出。imp匯入命令和exp匯出命令Oracle資料庫
- EXP邏輯匯出資料的呼叫方式
- 【EXP】使用EXP的QUERY選項匯出表中部分資料
- 【實驗】【PARTITION】exp匯出分割槽表資料
- 使用exp/imp匯出匯入資料(邏輯備份恢復)
- Oracle中exp,imp(匯入匯出)資料遷移注意事項Oracle
- 使用Oracle 的 imp ,exp 命令實現資料的匯入匯出Oracle
- 【EXP/IMP】使用EXP /IMP工具“模糊”匯出和匯入
- shell,ant指令碼實現自動資料泵(exp.expdp)匯出匯入資料指令碼
- Oracle匯入(imp )與匯出(exp )Oracle
- 【ORACLE 匯入匯出】exp 錯誤Oracle
- ORACLE匯入匯出命令exp/impOracle
- 資料庫匯入匯出時報ORA-01843的解決方法資料庫
- Windows DOS窗體下Oracle 資料庫的匯入匯出(IMP/EXP)命令WindowsOracle資料庫
- 低版本exp連線到高版本庫進行匯出,匯出資料為空
- 資料泵匯出時報錯ORA-1422錯誤
- 如何用exp 匯出 某個表的某幾列資料
- 建立Azure Blob Snapshot的指令碼指令碼
- Oracle 遠端匯出匯入 imp/expOracle
- 【匯入匯出】EXP-00068分析
- exp/imp匯出匯入工具的使用
- 【原創】比較資料泵和exp/imp對相同資料匯出/匯入的效能差異
- 用EXP/IMP從高版本資料庫匯出至低版本資料庫匯入實驗資料庫
- 在LINUX下用EXP匯出資料時出現EXP-00091錯誤的解決方法Linux
- 使用Exp和Expdp匯出資料的效能對比與優化優化
- 關於使用exp按照條件匯出資料的問題(摘)