Oracle9i IMP 含LOB Table時候出現Segmentation fault, Bug:3091499
. . importing table "STREAMDATA" Segmentation fault
主題: IMPORT OF TABLE WITH LOB GENERATES CORE DUMP
文件 ID: 註釋:279722.1 型別: PROBLEM
上次修訂日期: 02-AUG-2004 狀態: MODERATED
The information in this article applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.3
This problem can occur on any platform.
Symptoms
IMPORT OF TABLE WITH LOB GENERATES CORE DUMP
Cause
Bug 3091499
Importing a table having a clob created with chunksize = 32k
Error Details:
-------------
. importing DBAPIDB1's objects into DBAPIDB1
. . importing table "TE2006"Segmentation fault
Trace from the Core Dump:
------------------------
lmmstrmlr 44
lmmstmrg D4
lmmstmrg D4
lmmstfree 104
lmmfree C0
impmfr 24
impplb 5BC
impins 22B8
do_insert 48C
imptabwrk F4
impdta 41C
impdrv 2D68
main 14
__start 94
Fix
FIX:
---
Apply the patch for Bug:3091499
WORKAROUND:
----------
Before import, create the table with chunksize <= 16K and run import setting ignore=y
References
Bug 3091499 - Import Of Table With Lob Generates Core Dump
主題: IMPORT OF TABLE WITH LOB GENERATES CORE DUMP
文件 ID: 註釋:279722.1 型別: PROBLEM
上次修訂日期: 02-AUG-2004 狀態: MODERATED
The information in this article applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.3
This problem can occur on any platform.
Symptoms
IMPORT OF TABLE WITH LOB GENERATES CORE DUMP
Cause
Bug 3091499
Importing a table having a clob created with chunksize = 32k
Error Details:
-------------
. importing DBAPIDB1's objects into DBAPIDB1
. . importing table "TE2006"Segmentation fault
Trace from the Core Dump:
------------------------
lmmstrmlr 44
lmmstmrg D4
lmmstmrg D4
lmmstfree 104
lmmfree C0
impmfr 24
impplb 5BC
impins 22B8
do_insert 48C
imptabwrk F4
impdta 41C
impdrv 2D68
main 14
__start 94
Fix
FIX:
---
Apply the patch for Bug:3091499
WORKAROUND:
----------
Before import, create the table with chunksize <= 16K and run import setting ignore=y
References
Bug 3091499 - Import Of Table With Lob Generates Core Dump
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-84371/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- pytorch 程式碼出現 ‘segmentation fault (core dump)’ 問題PyTorchSegmentation
- 當import matplotlib.pyplot as ply 出現Segmentation fault (core dumped)ImportSegmentation
- tacmd[203] no segmentation fault(coredump)ACMSegmentation
- Segmentation fault (coredump)的解決Segmentation
- imp 時出現在ORA-00942: table or view does not existView
- 執行sqlplus遭遇Segmentation FaultSQLSegmentation
- mysql執行命令報segmentation fault 錯誤MySqlSegmentation
- sqplus 的 segmentation fault錯誤及解決!Segmentation
- netca 啟動時報錯(Segmentation fault(coredump))Segmentation
- TABLE size (including table,index,lob,lobindex)Index
- 新搭建的mysql登陸報錯mysql Segmentation fault (core dumped)MySqlSegmentation
- SQLLDR利用EXPRESSION生成LOGFILE的檔名導致SEGMENTATION FAULTSQLExpressSegmentation
- 從程式棧記憶體底層原理到Segmentation fault報錯記憶體Segmentation
- 什麼是Segmentation fault(Core Dump)? + 我遇到的例項問題Segmentation
- 10203 Rman執行delete obsolete報錯Segmentation faultdeleteSegmentation
- 【分散式Tensorflow(0.11.0)問題 未解決】Segmentation fault (core dumped)分散式Segmentation
- 當出現記憶體洩漏的時候記憶體
- 【Oracle】安裝完oracle 9i,執行sqlplus 遇到Segmentation FaultOracleSQLSegmentation
- 包含觸發器的LOB表執行IMP導致EMPTY_LOB變為空觸發器
- imp匯入時default 按table提交,使用commit按buffer提交MIT
- 什麼時候釋出
- [BUG反饋]升級OT1.1開發版的時候出錯了
- pycharm啟動時候出現 fail to load jvm dllPyCharmAIJVM
- 新版什麼時候釋出?
- Dev 日誌 | 一次 Segmentation Fault 和 GCC Illegal Instruction 編譯問題排查devSegmentationGCStruct編譯
- scp時候出現ssh Connection refused的解決方案
- 安裝oracleRAC遇到的執行rootconfig: line 815: 10338 Segmentation faultOracleSegmentation
- 【LOB】使用資料泵時 LOB 欄位存放位置
- 【故障處理】因授權資訊丟失導致IMP時出現IMP-00041錯誤的模擬與分析
- EXP,IMP遷移資料庫的時候註釋亂碼解決方法資料庫
- oracle中用Create Table建立表時,Storage中引數的含義!Oracle
- javascript中做減法時,出現小數位增加bugJavaScript
- DEBUG : Eclipse Debug 時出現 Cannot connect to VM select failed錯誤EclipseAI
- 關於線上的bug什麼時候修復的思考
- java 既然出現double型別×2的n次方的時候計算結果出現偏差Java型別
- ubuntu7下軟體執行出現segment fault錯誤Ubuntu
- 解決dbms_lob.loadfromfile載入lob資料後出現亂碼的問題
- input設定寬高時候會出現top有內邊距: