imp ora-00604 ora-06502错误
ptm-c1的是生产库,一直都是10.2.0.4
客户端是windows版10.2.0.1
pri-1是测试库,之前的版本是10.2.0.1,导出导入都是正常的,上个星期把测试库升级到10.2.0.4就出
现了今天无法导入的问题
[oracle@pri-1 ~]$ imp test/test fromuser=pdid touser=test file=data_m3415.dmp
Import: Release 10.2.0.4.0 - Production on Mon May 31 11:32:34 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by PDID, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing PDID's objects into TEST
IMP-00017: following statement failed with ORACLE error 604:
... ...
IMP-00003: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 6
Import terminated successfully with warnings.
加大buffer,而且在创建包时也出现了同样的问题
[oracle@pri-1 ~]$ imp test/test fromuser=pdid touser=test buffer=1000000000
file=data_m3415.dmp
Import: Release 10.2.0.4.0 - Production on 星期一 5月 31 12:08:46 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining<