Uncategorized

Data Pump import makes me crabby

Posted by

I’m sitting here watching the import of a moderately sized database via transportable tablespaces. You know…the thing you use when a full export / import would be too slow, and this is meant to be … well…fast.

And fast it is.. until it reaches the following step:

Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS

Now understandably, there’s plenty of stats to import, so its fair that it should take a little while. But a quick look at the SQL that’s being run, reveals something truly hideous. You’ll see a succession of giant PL/SQL blocks, chock full of literals and row-by-row (slow by slow) processing. Things like this:

DECLARE   c varchar2(60)
   nv varchar2(1)
   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'
   s varchar2(60) := 'MY_SCHEMA'
   t varchar2(60) := 'MY_TABLE'
   p varchar2(60) := 'MY_PARTITION'
   sp varchar2(1)
   stmt varchar2(300) := 'INSERT INTO "SYS"."IMPDP_STATS" (type,version,c1,c2,c3,c4,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,r1,r2,r3,flags,cl1) VALUES (:1,6,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24)'
BEGIN  
   DELETE FROM "SYS"."IMPDP_STATS"
   INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n9,n10,n11,n12,d1) VALUES ('T',6,2,t,p,sp,s,795877,2232,61,795877,0,NULL,NULL,NULL,TO_DATE('2015-01-11 01:13:44',df))  
   c := 'COL1'
   EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,7,6.40253651379786E-07,7,9627,0,2456710,2456716,8,1,1639,2456710,0,TO_DATE('2015-01-11 01:13:44',df),'78720215010101','7872021B010101',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,7,6.40253651379786E-07,7,9627,0,2456710,2456716,8,1,4073,2456711,0,TO_DATE('2015-01-11 01:13:44',df),'78720215010101','7872021B010101',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,7,6.40253651379786E-07,7,9627,0,2456710,2456716,8,1,5520,2456712,0,TO_DATE('2015-01-11 01:13:44',df),'78720215010101','7872021B010101',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,7,6.40253651379786E-07,7,9627,0,2456710,2456716,8,1,6305,2456713,0,TO_DATE('2015-01-11 01:13:44',df),'78720215010101','7872021B010101',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,7,6.40253651379786E-07,7,9627,0,2456710,2456716,8,1,7183,2456714,0,TO_DATE('2015-01-11 01:13:44',df),'78720215010101','7872021B010101',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,7,6.40253651379786E-07,7,9627,0,2456710,2456716,8,1,8431,2456715,0,TO_DATE('2015-01-11 01:13:44',df),'78720215010101','7872021B010101',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,7,6.40253651379786E-07,7,9627,0,2456710,2456716,8,1,9627,2456716,0,TO_DATE('2015-01-11 01:13:44',df),'78720215010101','7872021B010101',nv,2,nv
  c := 'COL2'
   EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,4,6.40253651379786E-07,4,9627,0,3.64799419131279E+35,4.32664361665097E+35,3,1,2610,3.64799419131279E+35,0,TO_DATE('2015-01-11 01:13:44',df),'4642','5354',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,4,6.40253651379786E-07,4,9627,0,3.64799419131279E+35,4.32664361665097E+35,3,1,2650,3.65042808046523E+35,0,TO_DATE('2015-01-11 01:13:44',df),'4642','5354',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,4,6.40253651379786E-07,4,9627,0,3.64799419131279E+35,4.32664361665097E+35,3,1,9626,4.25768342399856E+35,0,TO_DATE('2015-01-11 01:13:44',df),'4642','5354',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,4,6.40253651379786E-07,4,9627,0,3.64799419131279E+35,4.32664361665097E+35,3,1,9627,4.32664361665097E+35,0,TO_DATE('2015-01-11 01:13:44',df),'4642','5354',nv,2,nv
  c := 'COL3'
   EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,0,9325,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,1,51741,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,2,51742,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,3,51743,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,4,51745,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,6,51746,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,7,51747,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,8,51748,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,9,51749,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,11,51750,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,12,51751,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,14,51752,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,15,51753,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,16,51754,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,17,51755,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,18,51757,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,19,51758,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,21,51760,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,23,51761,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,24,51762,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,25,51765,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,26,51766,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,27,51767,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,33,51770,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,36,51771,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,38,51772,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,40,51773,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,41,51777,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,42,51778,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,43,51779,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,45,51780,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,46,51782,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,47,51783,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,48,51786,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,49,51787,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,50,51788,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,51,51789,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,52,51790,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,53,51791,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,54,51792,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,55,51793,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,56,51794,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,57,51795,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,58,51796,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,59,51797,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,60,51798,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,61,51799,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,62,51800,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,63,51801,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,64,51802,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,65,51803,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,67,51804,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,68,51806,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,69,51807,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,70,51810,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,72,51811,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,73,51815,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,74,51819,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,75,51820,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,76,51821,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,77,51824,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,78,51825,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,79,51827,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,80,51829,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,81,51830,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,82,51833,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,83,51834,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,84,51835,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,85,51837,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,86,51840,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,87,51841,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,88,51842,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,89,51843,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,90,51844,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,91,51846,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,92,51847,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,93,51849,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,94,51851,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,95,51852,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,96,51853,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,97,51855,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,99,51856,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,100,51858,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,101,51859,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,102,51861,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,103,51862,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,104,51863,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,105,51864,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,106,51866,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,107,51867,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,108,51869,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,109,51870,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,110,51871,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,111,51873,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,113,51874,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,114,51875,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,115,51876,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,116,51877,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,117,51878,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,119,51879,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,120,51880,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,121,51881,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,122,51882,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,123,51884,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,124,51885,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,125,51886,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,126,51887,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,127,51888,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,128,51889,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,129,51891,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,130,51892,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,131,51894,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,132,51896,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,133,51901,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,134,51902,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,135,51903,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,136,51904,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,137,51905,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,139,51910,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,140,51911,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,141,51912,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,142,51914,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,143,51915,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,144,51917,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,145,51918,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,146,51919,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,147,51920,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,148,51921,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,149,51922,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,150,51924,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,151,51925,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,152,51926,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,153,51997,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,155,51999,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,156,52001,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,157,52004,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,163,52005,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,164,52006,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,165,52007,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,166,52008,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,170,52012,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,171,52014,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,172,52015,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,173,52016,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,175,52017,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,177,52018,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,178,52031,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,179,52040,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,180,52138,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,181,52146,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,182,52533,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,183,53076,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,184,6770894,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,185,34964939,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,186,34964971,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,187,35013110,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,188,35013117,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,189,35013120,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,190,35013127,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,191,35016806,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,192,35017376,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,193,35017433,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,194,35017486,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,195,35017703,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,196,35018421,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,197,35018426,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,198,35018438,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,199,35018450,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
  EXECUTE IMMEDIATE stmt USING 'C',t,p,sp,c,s,5543,.00249376558603491,5543,9627,0,9325,35029221,6,1,200,35018503,0,TO_DATE('2015-01-11 01:13:44',df),'C25E1A','C424035D16',nv,2,nv
...
...

And it just goes on and on and on.

My advice would be:

Never let data pump import manage you statistics, ie, use EXCLUDE=TABLE_STATISTICS for any job with a large amount of objects.

Either recalculate them yourself, or export / import them via DBMS_STATS. Anything to avoid the drivel above 😦

4 comments

  1. Ah! The joys of tools driven by XML…
    I’ve made it a rule now to never do stats via datapump.
    The dbms_stats export/move stats table/dbms_stats import process is soooooo much faster, there is simply no comparison.
    Why on earth can’t datapump do the same instead of re-inventing a (square) wheel is beyond me.
    Chinese walls between development teams?…

    Reply

  2. As were are about to embark on a POC for moving a rather large amount of data via TTS, managing the stats ourselves seems the wise course.
    For this particular large and very busy database, managing all of the stats ourselves is the only way it has every worked (nearly) properly, so nothing new here I guess.

    Reply
  3. Pingback: Making Datapump Import Stat-tastically faster | The Anti-Kyte
  4. Pingback: Making Datapump Import Stat-tastically faster - Oracle - Oracle - Toad World

Got some thoughts? Leave a comment

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.