;;; Import: Release 10.2.0.4.0 - Production on Saturday, 16 July, 2011 0:34:17 Copyright (c) 2003, 2007, Oracle. All rights reserved. ;;; Connected to: Oracle Database 10g Release 10.2.0.4.0 - Production Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/********@capgent directory=dp_exp_dir dumpfile=exp_DNBI_1788475.dmp logfile=imp_DNBI_1788475.log remap_schema=DNBI:PRERELEASE Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "PRERELEASE"."INV_TXN" 126.3 MB 472517 rows . . imported "PRERELEASE"."LDR_LOGDET" 86.30 MB 1121179 rows . . imported "PRERELEASE"."REMINDER_LOG" 50.49 MB 1038487 rows . . imported "PRERELEASE"."CST_HDR" 42.57 MB 235961 rows . . imported "PRERELEASE"."ACCR_TXN" 38.57 MB 355803 rows . . imported "PRERELEASE"."STS_LOG" 12.67 MB 165740 rows . . imported "PRERELEASE"."CMTS_LOG" 1.800 MB 15610 rows . . imported "PRERELEASE"."ADD_HDR" 13.87 MB 71714 rows . . imported "PRERELEASE"."EM_LOG" 16.80 MB 28917 rows . . imported "PRERELEASE"."TODO_LOG" 10.94 MB 83259 rows . . imported "PRERELEASE"."WF_INSTANCE" 7.798 MB 155135 rows . . imported "PRERELEASE"."WF_STRING_PROPERTIES" 5.104 MB 155135 rows . . imported "PRERELEASE"."WF_TIMESTAMP_PROPERTIES" 5.507 MB 153289 rows . . imported "PRERELEASE"."CST_AGEHDR" 1.984 MB 44798 rows . . imported "PRERELEASE"."WF_TRANSACTION_SCHEDULE" 6.132 KB 4 rows . . imported "PRERELEASE"."WF_ACTIVITY" 1.163 MB 47924 rows . . imported "PRERELEASE"."WF_SCHED_STRING_PROPERTIES" 5.968 KB 4 rows . . imported "PRERELEASE"."LDR_LOG" 254.5 KB 2054 rows . . imported "PRERELEASE"."JOBS_STRING_PROPERTIES" 224.1 KB 5305 rows . . imported "PRERELEASE"."USR_HDR" 219.7 KB 1189 rows . . imported "PRERELEASE"."PLAN_TABLE" 63.96 KB 73 rows . . imported "PRERELEASE"."JOBS_QUEUE" 65.78 KB 750 rows . . imported "PRERELEASE"."RLV_LNKHDR" 71.27 KB 1272 rows . . imported "PRERELEASE"."RL_LNKHDR" 62.59 KB 1297 rows . . imported "PRERELEASE"."RPT_LOG" 42.20 KB 264 rows . . imported "PRERELEASE"."ACT_HDR" 10.05 KB 42 rows . . imported "PRERELEASE"."AGE_HDR" 19.11 KB 243 rows . . imported "PRERELEASE"."AMDL_HDR" 7.960 KB 23 rows . . imported "PRERELEASE"."ATTMTS_LOG" 14.83 KB 27 rows . . imported "PRERELEASE"."BNK_HDR" 15.67 KB 2 rows . . imported "PRERELEASE"."CSTPE_HDR" 7.328 KB 15 rows . . imported "PRERELEASE"."CTRY_HDR" 7.093 KB 1 rows . . imported "PRERELEASE"."DB_CHANGE_LOG" 22.41 KB 67 rows . . imported "PRERELEASE"."ENTTY_HDR" 8.625 KB 23 rows . . imported "PRERELEASE"."EVENT_HDR" 7.765 KB 16 rows . . imported "PRERELEASE"."INVSUM_DET" 11.97 KB 4 rows . . imported "PRERELEASE"."INVTPE_HDR" 7.257 KB 14 rows . . imported "PRERELEASE"."INVTXN_DET" 27.31 KB 39 rows . . imported "PRERELEASE"."INV_NOTES" 8.75 KB 12 rows . . imported "PRERELEASE"."JOBS_TIMESTAMP_PROPERTIES" 15.32 KB 268 rows . . imported "PRERELEASE"."PRTY_HDR" 7.187 KB 4 rows . . imported "PRERELEASE"."PYMT_TXN" 12.96 KB 2 rows . . imported "PRERELEASE"."PYTTXN_DET" 7.726 KB 2 rows . . imported "PRERELEASE"."RLA_LNKHDR" 16.10 KB 359 rows . . imported "PRERELEASE"."RLRT_LNKHDR" 10.55 KB 187 rows . . imported "PRERELEASE"."RL_HDR" 10.54 KB 22 rows . . imported "PRERELEASE"."RPTCFG_HDR" 24.65 KB 182 rows . . imported "PRERELEASE"."RSNCDE_HDR" 20.22 KB 281 rows . . imported "PRERELEASE"."SBMDL_DET" 9.570 KB 73 rows . . imported "PRERELEASE"."SB_HDR" 16.96 KB 21 rows . . imported "PRERELEASE"."STD_HDR" 14.19 KB 96 rows . . imported "PRERELEASE"."STS_HDR" 25.39 KB 149 rows . . imported "PRERELEASE"."TMT_HDR" 21.60 KB 94 rows . . imported "PRERELEASE"."TODO_LOGDT" 15.24 KB 66 rows . . imported "PRERELEASE"."USG_HDR" 6.789 KB 1 rows . . imported "PRERELEASE"."USRCST_LNKHDR" 10.93 KB 74 rows . . imported "PRERELEASE"."WFE_HDR" 21.48 KB 139 rows . . imported "PRERELEASE"."WF_HDR" 7.257 KB 4 rows . . imported "PRERELEASE"."WF_LOG" 26.24 KB 769 rows . . imported "PRERELEASE"."ACC_HDR" 0 KB 0 rows . . imported "PRERELEASE"."ADJTXN_DET" 0 KB 0 rows . . imported "PRERELEASE"."ADJ_TXN" 0 KB 0 rows . . imported "PRERELEASE"."ALTC_HDR" 0 KB 0 rows . . imported "PRERELEASE"."ALTP_HDR" 0 KB 0 rows . . imported "PRERELEASE"."ALT_LOG" 0 KB 0 rows . . imported "PRERELEASE"."AUDIT_LOG" 0 KB 0 rows . . imported "PRERELEASE"."CDST_DET" 0 KB 0 rows . . imported "PRERELEASE"."CDST_HDR" 0 KB 0 rows . . imported "PRERELEASE"."CGC_HDR" 0 KB 0 rows . . imported "PRERELEASE"."COM_LOG" 0 KB 0 rows . . imported "PRERELEASE"."CRR_HDR" 0 KB 0 rows . . imported "PRERELEASE"."CRT_HDR" 0 KB 0 rows . . imported "PRERELEASE"."CSG_HDR" 0 KB 0 rows . . imported "PRERELEASE"."CURR_HDR" 0 KB 0 rows . . imported "PRERELEASE"."CYL_HDR" 0 KB 0 rows . . imported "PRERELEASE"."DISP_TXN" 0 KB 0 rows . . imported "PRERELEASE"."DM_HDR" 0 KB 0 rows . . imported "PRERELEASE"."DSCE_HDR" 0 KB 0 rows . . imported "PRERELEASE"."DSCM_DET" 0 KB 0 rows . . imported "PRERELEASE"."DSCM_HDR" 0 KB 0 rows . . imported "PRERELEASE"."DT_HDR" 0 KB 0 rows . . imported "PRERELEASE"."FLA_LNKHDR" 0 KB 0 rows . . imported "PRERELEASE"."FLD_LOG" 0 KB 0 rows . . imported "PRERELEASE"."FL_HDR" 0 KB 0 rows . . imported "PRERELEASE"."INRLE_HDR" 0 KB 0 rows . . imported "PRERELEASE"."INVSR_DET" 0 KB 0 rows . . imported "PRERELEASE"."MTH_HDR" 0 KB 0 rows . . imported "PRERELEASE"."MTH_LOG" 0 KB 0 rows . . imported "PRERELEASE"."MTH_LOGDET" 0 KB 0 rows . . imported "PRERELEASE"."PCGT_HDR" 0 KB 0 rows . . imported "PRERELEASE"."PTCR_HDR" 0 KB 0 rows . . imported "PRERELEASE"."PTRR_HDR" 0 KB 0 rows . . imported "PRERELEASE"."PYT_HDR" 0 KB 0 rows . . imported "PRERELEASE"."QC_HDR" 0 KB 0 rows . . imported "PRERELEASE"."REG_HDR" 0 KB 0 rows . . imported "PRERELEASE"."RLCFG_HDR" 0 KB 0 rows . . imported "PRERELEASE"."RLD_LNKHDR" 0 KB 0 rows . . imported "PRERELEASE"."RLETE_HDR" 0 KB 0 rows . . imported "PRERELEASE"."RLGLK_HDR" 0 KB 0 rows . . imported "PRERELEASE"."RLGRP_HDR" 0 KB 0 rows . . imported "PRERELEASE"."RPTMT_HDR" 0 KB 0 rows . . imported "PRERELEASE"."SBDBLK_HDR" 0 KB 0 rows . . imported "PRERELEASE"."SBSTD_HDR" 0 KB 0 rows . . imported "PRERELEASE"."SCHEDULE_HDR" 0 KB 0 rows . . imported "PRERELEASE"."SITE_HDR" 0 KB 0 rows . . imported "PRERELEASE"."USG_LNKHDR" 0 KB 0 rows . . imported "PRERELEASE"."USR_LOG" 0 KB 0 rows . . imported "PRERELEASE"."WFD_HDR" 0 KB 0 rows . . imported "PRERELEASE"."WF_ACTIVITY_STATE" 0 KB 0 rows . . imported "PRERELEASE"."WF_SCHEDULE" 0 KB 0 rows . . imported "PRERELEASE"."WF_SCHED_TIMESTAMP_PROPERTIES" 0 KB 0 rows . . imported "PRERELEASE"."WF_STATE" 0 KB 0 rows . . imported "PRERELEASE"."XRTTPE_HDR" 0 KB 0 rows Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS ORA-39083: Object type INDEX_STATISTICS failed to create with error: ORA-01403: no data found ORA-01403: no data found Failing sql is: DECLARE IND_NAME VARCHAR2(60); IND_OWNER VARCHAR2(60); BEGIN DELETE FROM "SYS"."IMPDP_STATS"; SELECT index_name, index_owner INTO IND_NAME, IND_OWNER FROM (SELECT UNIQUE sgc1.index_name, sgc1.index_owner, COUNT(*) mycount FROM sys.ku$_find_sgc_view sgc1, TABLE (sgc1.col_list) myc Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE ORA-39082: Object type ALTER_PROCEDURE:"PRERELEASE"."ALL_ENTITY_AGE_CALCULATIONS" created with compilation warnings Processing object type SCHEMA_EXPORT/VIEW/VIEW Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/TRIGGER Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 2 error(s) at 00:38:04