1 0 0 0 0 0 \{]` 0 0 0 0 0 0 0 0 0 ANALYZE TABLE_STATISTICS ANALYZE TABLE " "." " COMPUTE STATISTICS ; DBMS_STATS TABLE_STATISTICS BEGIN DBMS_STATS.SET_TABLE_STATS( '" "', '" "', '" "', NULL, NULL,NULL, , NULL, , NULL, , NULL, +4,NULL,FALSE, 0+4,NULL,FALSE, , NULL, ); NULL); END; DBMS_STATS TABLE_STATISTICS TABLE DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := ' '; SREC.MINVAL := NULL; SREC.MAXVAL := ' '; SREC.MAXVAL := NULL; SREC.EAVS := ; SREC.CHVALS := DBMS_STATS.CHARARRAY( , ' ' ); SREC.NOVALS := DBMS_STATS.NUMARRAY( , ); SREC.BKVALS := DBMS_STATS.NUMARRAY( , ); SREC.EPC := ; SREC.NOVALS := DBMS_STATS.NUMARRAY( , ); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; SREC.NOVALS := DBMS_STATS.NUMARRAY(); SREC.BKVALS := DBMS_STATS.NUMARRAY(); SREC.EPC := 0; DBMS_STATS.SET_COLUMN_STATS( '" "', '" "', '" "', '" "', NULL, NULL,NULL, , , ,srec, , + 4); END; BEGINNING INSERT INTO " "." " (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n10,n11,n12,d1) VALUES ('T',5, ,t, p, sp, s, , NULL, , NULL, , NULL, , NULL, , NULL, , NULL, NULL, 0000-00-00 NULL); TO_DATE(' ',df)); NULL); MIDDLE c := ; c := ; ENDING EXECUTE IMMEDIATE stmt USING t, p, sp, c, s, , 0, , 0, , 0, , nv, , 0, , nv, , nv, , 0, 1, nv, , nv, , nv, 0000-00-00 nv, TO_DATE(' ',df), nv, ' ', nv, ' ', nv, ' ',4+ nv, ; 0; DBMS_STATS TABLE_STATISTICS BEGIN DBMS_STATS.LOCK_TABLE_STATS( '" "', '" "', 'ALL'); 'CACHE'); 'DATA'); 'ALL'); END; DBMS_STATS INDEX_STATISTICS DECLARE I_N VARCHAR2(60); I_O VARCHAR2(60); c DBMS_METADATA.T_VAR_COLL; df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'; BEGIN DELETE FROM " "." "; 1 0 0 DBMS_STATS.IMPORT_INDEX_STATS('"' || i_o || '"','"' || i_n || '"',NULL,'" "',NULL,'" "'); DELETE FROM " "." "; END; DBMS_STATS INDEX_STATISTICS DECLARE I_O VARCHAR2(60); I_N VARCHAR2(60); c dbms_metadata.t_var_coll; BEGIN DBMS_STATS.SET_INDEX_STATS('"' || i_o || '"','"' || i_n || '"', '" "', '" "', NULL, NULL,NULL, , NULL, , NULL, , NULL, , NULL, , NULL, , NULL, , NULL, +4,NULL,FALSE,NULL, 0+4,NULL,FALSE,NULL, , NULL, ); NULL); END; INSERT INTO " "." " (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES ('I',5, , I_N, ' ', NULL, ' ', NULL, I_O, , NULL, , NULL, , NULL, , NULL, , NULL, , NULL, , NULL, , NULL, NULL, , NULL, , NULL, NULL, 0000-00-00 NULL, TO_DATE(' ',df), NULL, ); NULL); c( ) := ; DBMS_METADATA.GET_STAT_INDNAME( ' ', ' ',c, ,i_o,i_n); i_n := ' '; i_o := ' '; SYS your_schema IMPDP_STATS your_stats_table DBMS_METADATA.GET_STAT_COLNAME( ' ', NULL, ' ', NULL, ' ', NULL, ' ', NULL, ) 0) ' ' ' ' DBMS_STATS.IMPORT_TABLE_STATS( '" "', '" "', NULL,'" "',NULL,NULL,'" "'); DELETE FROM " "." "; END; DBMS_STATS TABLE_STATISTICS DECLARE c varchar2(60); nv varchar2(1); df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'; s varchar2(60) := ' '; t varchar2(60) := ' '; p varchar2(60) := ' '; p varchar2(1); sp varchar2(60) := ' '; sp varchar2(1); stmt varchar2(300) := 'INSERT INTO " "." " (type,version,c1,c2,c3,c4,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,d1,r1,r2,ch1,flags) VALUES (''C'',5,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21)'; BEGIN DELETE FROM " "." "; NULL;