IMP 导入数据报错 OCI-21500 OCI-22275
来源:互联网 发布:网络诈骗方法揭秘 编辑:程序博客网 时间:2024/06/14 11:32
IMP导入数据报错如下:
OCI-21500: internal error code, arguments: [kgepop: no error frame to pop to], [], [], [], [], [], [], []
OCI-22275: invalid LOB locator specified
xExExE@@@@@@@@Errors in file :
OCI-21500: internal error code, arguments: [kgepop: no error frame to pop to], [], [], [], [], [], [], []
OCI-22275: invalid LOB locator specified
xExExEpppppppp
illegal lob length marker 34981
bytesread = 00000000000
TABLE = HD_HDXX
IMP-00098: INTERNAL ERROR: impgst2
报错说明:
OCI-21500: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
Cause: This is the generic error number for the OCI environment (client-side) internal errors. This indicates that the OCI environment has encountered an exceptional condition.Action: Report as a bug - the first argument is the internal error number.
OCI-22275: invalid LOB locator specified
Cause: There are several causes: (1) the LOB locator was never initialized; (2) the locator is for a BFILE and the routine expects a BLOB/CLOB/NCLOB locator; (3) the locator is for a BLOB/CLOB/NCLOB and the routine expects a BFILE locator; (4) trying to update the LOB in a trigger body -- LOBs in trigger bodies are read only.
Action: For (1), initialize the LOB locator by selecting into the locator variable or by setting the LOB locator to empty. For (2) and (3), pass the correct type of locator into the routine. For (4), remove the trigger body code that updates the LOB value.
解决思路:
1.数据导出的时候按照 用户进行导出,并且采用了直接路径 direct=y
exp xyy/xyy@sspt OWNER=GSYY DIRECT=Y RECORDLENGTH=65535 BUFFER=104857600 FILE=/opt/oradata/exp/GSYY.dmp LOG=/opt/oradata/exp/log/GSYY.log
查询导入日志,发现并未报错:
. . exporting table FP_HGWSPZ 0 rows exported
. . exporting table GS_DJ_NSRXX 0 rows exported
. . exporting table HD_HDXX 3219563 rows exported
2.查询表 HD_HDXX ,发现含有LOB字段数据
SQL> desc GSYY.HD_HDXX;
Name Null? Type
----------------------------------------- -------- ----------------------------
SBNY NOT NULL CHAR(6)
NSRSBH NOT NULL VARCHAR2(20)
SWJG_DM NOT NULL VARCHAR2(11)
LRR_DM NOT NULL VARCHAR2(11)
LRRQ NOT NULL DATE
XGR_DM NOT NULL VARCHAR2(11)
XGRQ NOT NULL DATE
HDXX CLOB
FPLGXX VARCHAR2(4000)
JXFP_MX CLOB
XXFP_HZ VARCHAR2(4000)
HGWSFP_MX CLOB
JDCJXFP_MX CLOB
3.直接路径导出 direct=y 不支持导出含有LOB、BFILE等大对象的表,进行单独 导出 GSYY.HD_HDXX,再进行导入,发现正常无报错。
- IMP 导入数据报错 OCI-21500 OCI-22275
- OCI
- oci
- oci连接程序编译报错
- OCI 批量数据操作
- OCI批量获取数据
- imp导入报错
- IMP导入数据 报错 IMP-00058 ORA-01691 IMP-00028
- navicat 连接Oracle 报错:Cannot load OCI DLL, 126
- navicat 连接Oracle 报错:Cannot load OCI DLL, 126
- [Navicat] 连接Oracle报错_Cannot load OCI DLL 87
- navicat permium 连接Oracle 报错:Cannot load OCI DLL
- [Navicat] 连接Oracle报错_Cannot load OCI DLL 87
- [Navicat] 连接Oracle报错_Cannot load OCI DLL 87
- [Navicat] 连接Oracle报错_Cannot load OCI DLL 87
- [Navicat] 连接Oracle报错_Cannot load OCI DLL 87
- oracle服务启动报错,Navicat链接报Cannot load OCI DLL,87:...和Cannot load OCI DLL,193:...错误
- Oracle OCI :OCI说明
- non-linear stationary subspace analysis with application to video classification
- hadoop初学之--------程序格式
- linux系统禁止root用户通过ssh登录及ssh的访问控制
- STL的容器
- 家养公驴发飙咬断主人两手指 专家:处发情期
- IMP 导入数据报错 OCI-21500 OCI-22275
- 【HDOJ】1166 敌兵布阵 (线段树)
- java中接口的定义与实现
- 高速PCB电路板的信号完整性设计
- POJ 3670 , 3671 LIS
- 学习笔记 Treap
- 文件捆绑器分析
- LA 3026 - Period KMP
- 百度2013校园招聘笔试题(自动化平台、测试开发)