- 最后登录
- 2014-4-16
- 在线时间
- 34 小时
- 威望
- 85
- 金钱
- 512
- 注册时间
- 2012-4-25
- 阅读权限
- 50
- 帖子
- 28
- 精华
- 1
- 积分
- 85
- UID
- 390
|
1#
发表于 2012-5-25 15:32:56
|
查看: 7599 |
回复: 2
环境:aix5.3 oracle10.2.4 expdp出一份dmp,在suse11 oracle11.2.0.2里面impdp,系统数据库均是64位,suse11机器内存16G,sga=6g,pga=4g,就做了impdp操作,涉及一张30G左右的分区表及其上的两个各约10G的索引,导出和导入语句:
导出语句 expdp system/******* directory=expdp_dir tables=riskmgr.t_trans_info dumpfile=t_trans_info.dmp;
导入语句impdp mlsmgr/******* DIRECTORY=dmp_dir dumpfile=t_trans_info.dmp tables=riskmgr.t_trans_info remap_schema=riskmgr:mlsmgr remap_tablespace=riskdata:fxqtest_tbs
trace文件上传附件,impdp报错内容如下:
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-04030: out of process memory when trying to allocate 4088 bytes (PLS CGA hp,pdzgM64_New_Link)
Failing sql is:
DECLARE I_N VARCHAR2(60); I_O VARCHAR2(60); NV VARCHAR2(1); c DBMS_METADATA.T_VAR_COLL; df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'; stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,
ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-04030: out of process memory when trying to allocate 4088 bytes (PLS CGA hp,pdzgM64_New_Link)
Failing sql is:
DECLARE I_N VARCHAR2(60); I_O VARCHAR2(60); NV VARCHAR2(1); c DBMS_METADATA.T_VAR_COLL; df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'; stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,
ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-04030: out of process memory when trying to allocate 4088 bytes (PLS CGA hp,pdzgM64_New_Link)
Failing sql is:
DECLARE I_N VARCHAR2(60); I_O VARCHAR2(60); NV VARCHAR2(1); c DBMS_METADATA.T_VAR_COLL; df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'; stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc)
ORA-06512: at "SYS.KUPW$WORKER", line 1751
ORA-06512: at line 2
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 12 with process name "DW0B" prematurely terminated
ORA-31671: Worker process DW0B had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc)
ORA-06512: at "SYS.KUPW$WORKER", line 1751
ORA-06512: at line 2
Job "MLSMGR"."SYS_IMPORT_TABLE_01" stopped due to fatal error at 13:36:59 |
|