Home » RDBMS Server » Server Utilities » data pump error (11g)
data pump error [message #620821] |
Wed, 06 August 2014 07:39 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/93fc9c460da36b6af57d772a56d086de?s=64&d=mm&r=g) |
andrewscharles89
Messages: 25 Registered: July 2014
|
Junior Member |
|
|
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,:1
Processing object type SCHEMA_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/BITMAP_INDEX/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,:1
the error seems to be with PGA memory i guess.the question is how to reimport only the errored out data.how to gather index stats alone for complete schema
|
|
|
|
|
|
|
|
|
|
|
Re: data pump error [message #620841 is a reply to message #620837] |
Wed, 06 August 2014 10:11 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
Michel already told you.
Michel Cadot wrote on Wed, 06 August 2014 18:21
Use dbms_gather_stats package.
Or, if you really want to use data pump, use INCLUDE=INDEX_STATISTICS and other INCLUDE's to list all the indexes that were in error.
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sat Sep 07 20:23:09 CDT 2024
|