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; DBMS_STATS TABLE_STATISTICS DECLARE colname varchar2(60); BEGIN DELETE FROM " "." "; INSERT INTO " "." " (type, version, flags, c1, c2, c3, c5, n1, n2, n3, n4, n10, n11, n12, d1) VALUES ('T', 5, , ' ', ' ', NULL, ' ', NULL, ' ', , NULL, , NULL, , NULL, , NULL, , NULL, , NULL, NULL, 0000-00-00 NULL); TO_DATE(' ', 'YYYY-MM-DD:HH24:MI:SS')); NULL); colname := ; colname := ; DBMS_STATS.IMPORT_TABLE_STATS( '" "', '" "', NULL, '" "', NULL, NULL, '" "'); DELETE FROM " "." "; END; 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, ' ', ' ', NULL, ' ', NULL, colname, ' ', , 0, , 0, , 0, , NULL, , 0, , NULL, , NULL, , 0, 1, NULL, , NULL, , NULL, 0000-00-00 NULL, TO_DATE(' ', 'YYYY-MM-DD:HH24:MI:SS'), NULL, ' ', NULL, ' ', NULL, ' ', 4 + NULL, ); 0); DBMS_STATS TABLE_STATISTICS BEGIN DBMS_STATS.LOCK_TABLE_STATS( '" "', '" "', 'ALL'); 'CACHE'); 'DATA'); 'ALL'); END; DBMS_STATS INDEX_STATISTICS DECLARE IND_NAME VARCHAR2(60); IND_OWNER VARCHAR2(60); colname DBMS_METADATA.T_VAR_COLL; BEGIN DELETE FROM " "." "; 1 0 0 DBMS_STATS.IMPORT_INDEX_STATS('"' || ind_owner || '"', '"' || ind_name || '"', NULL, '" "', NULL, '" "'); DELETE FROM " "." "; END; DBMS_STATS INDEX_STATISTICS DECLARE IND_OWNER VARCHAR2(60); IND_NAME VARCHAR2(60); COLNAME dbms_metadata.t_var_coll; BEGIN DBMS_STATS.SET_INDEX_STATS('"' || ind_owner || '"', '"' || ind_name || '"', '" "', '" "', 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, , IND_NAME, ' ', NULL, ' ', NULL, IND_OWNER, , NULL, , NULL, , NULL, , NULL, , NULL, , NULL, , NULL, , NULL, NULL, , NULL, , NULL, NULL, 0000-00-00 NULL, TO_DATE(' ', 'YYYY-MM-DD:HH24:MI:SS'), NULL, ); NULL); colname( ) := ; DBMS_METADATA.GET_STAT_INDNAME( ' ', ' ', colname, , ind_owner, ind_name); ind_name := ' '; ind_owner := ' '; SYS your_schema IMPDP_STATS your_stats_table DBMS_METADATA.GET_STAT_COLNAME( ' ', NULL, ' ', NULL, ' ', NULL, ' ', NULL, ) 0) ' ' ' '