;;; Import: Release 11.1.0.7.0 - 64bit Production on Monday, 15 November, 2010 14:11:21 Copyright (c) 2003, 2007, Oracle. All rights reserved. ;;; Connected to: Oracle Database 11g Release 11.1.0.7.0 - 64bit Production Master table "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_TABLE_01": system/********@carbon parfile=impdp_cirqit_tbl.par Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "CIRQIT"."E_MAIL_LOG" 237.1 MB 1748169 rows . . imported "CIRQIT"."EXCHANGE_RATE_HISTORY" 3.082 MB 67951 rows . . imported "CIRQIT"."MPS_USER_CACHE" 793.5 KB 336 rows . . imported "CIRQIT"."PAPER" 1.426 MB 10872 rows ORA-31693: Table data object "CIRQIT"."PRODUCTION_PRICE" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-04091: table CIRQIT.PRODUCTION_PRICE is mutating, trigger/function may not see it ORA-06512: at "CIRQIT.REORDER_TRIG", line 8 ORA-04088: error during execution of trigger 'CIRQIT.REORDER_TRIG' ORA-31693: Table data object "CIRQIT"."SUPPLIER_SURVEY_RATING" failed to load/unload and is being skipped due to error: ORA-02291: integrity constraint (CIRQIT.SUPP_SURVEY_RATING_FK) violated - parent key not found . . imported "CIRQIT"."DESCRIPTOR_VALUE_LIST" 691.6 KB 19682 rows . . imported "CIRQIT"."ENTITY_FIELD_ITEM_TYPE_MAP" 616.8 KB 11430 rows . . imported "CIRQIT"."PRODUCT_MAP_MASTER" 604.8 KB 9901 rows . . imported "CIRQIT"."PAPER_MERCHANT_MAP" 529.6 KB 8371 rows . . imported "CIRQIT"."PRODUCTION_PRC_DESCRIPTOR_MAP" 414.0 KB 19846 rows . . imported "CIRQIT"."PRODUCT_SIZE" 273.1 KB 2163 rows . . imported "CIRQIT"."ENTITY_STATUS" 7.562 KB 3 rows . . imported "CIRQIT"."CALCULATION_CONFIG" 115.8 KB 380 rows . . imported "CIRQIT"."PAPER_BRAND" 144.4 KB 894 rows . . imported "CIRQIT"."ACTION_TYPE" 6.390 KB 1 rows . . imported "CIRQIT"."ADDRESS_TYPE" 7.710 KB 7 rows . . imported "CIRQIT"."ARTWORK_SOURCE_TYPE" 8.882 KB 12 rows . . imported "CIRQIT"."ARTWORK_TYPE" 8.054 KB 7 rows . . imported "CIRQIT"."BINDING" 21.57 KB 81 rows . . imported "CIRQIT"."BINDING_CATEGORY" 7.578 KB 6 rows . . imported "CIRQIT"."BINDING_PAGE_COUNT" 7.523 KB 16 rows . . imported "CIRQIT"."BINDING_TYPE" 13.96 KB 23 rows . . imported "CIRQIT"."CIRQIT_DOMAIN" 5.460 KB 2 rows . . imported "CIRQIT"."COATING_STYLE" 7.531 KB 7 rows . . imported "CIRQIT"."COATING_TYPE" 7.648 KB 9 rows . . imported "CIRQIT"."COST_CATEGORY" 20.02 KB 96 rows . . imported "CIRQIT"."COVERAGE" 7.820 KB 6 rows . . imported "CIRQIT"."CSS_ITEM_ITEM_TYPE_MAP" 5.992 KB 6 rows . . imported "CIRQIT"."CSS_SPEC_TYPE_MAP" 6.570 KB 11 rows . . imported "CIRQIT"."DELIVERY_METHOD" 7.25 KB 5 rows . . imported "CIRQIT"."DESKTOP_MINUTES" 7.328 KB 6 rows . . imported "CIRQIT"."DIE_CUT_FOR_BUSINESS_CARD" 7.187 KB 4 rows . . imported "CIRQIT"."DRILLING" 7.679 KB 9 rows . . imported "CIRQIT"."ENTITY_TYPE" 40 KB 173 rows . . imported "CIRQIT"."FLAP_EDGE" 6.906 KB 2 rows . . imported "CIRQIT"."FLAP_STYLE" 7.453 KB 6 rows . . imported "CIRQIT"."GLUE_TAB" 7 KB 2 rows . . imported "CIRQIT"."IMPRESSION_METHOD" 6.742 KB 9 rows . . imported "CIRQIT"."INK" 7.648 KB 10 rows . . imported "CIRQIT"."INK_COVERAGE" 7.648 KB 4 rows . . imported "CIRQIT"."ITEM_TYPE" 24.25 KB 87 rows . . imported "CIRQIT"."LABELING_OPTION" 7.148 KB 4 rows . . imported "CIRQIT"."MAILING_OPTION" 7.070 KB 4 rows . . imported "CIRQIT"."OPENING_FEATURES" 7.101 KB 4 rows . . imported "CIRQIT"."ORG_TYPE" 8.890 KB 9 rows . . imported "CIRQIT"."PAPER_CATEGORY" 10.39 KB 28 rows . . imported "CIRQIT"."PAPER_COLOR" 97.22 KB 589 rows . . imported "CIRQIT"."PAPER_FEE_TYPE" 6.984 KB 2 rows . . imported "CIRQIT"."PAPER_FINISH" 28.57 KB 146 rows . . imported "CIRQIT"."PAPER_FINISH_SIDE" 10.01 KB 23 rows . . imported "CIRQIT"."PAPER_GRADE" 26.64 KB 124 rows . . imported "CIRQIT"."PAPER_GRAIN" 8.085 KB 7 rows . . imported "CIRQIT"."PAPER_METHOD" 8.492 KB 14 rows . . imported "CIRQIT"."PAPER_SOURCE" 7.398 KB 4 rows . . imported "CIRQIT"."PAPER_SUPPLY_TYPE" 6.968 KB 3 rows . . imported "CIRQIT"."PAPER_WEIGHT" 32.76 KB 267 rows . . imported "CIRQIT"."PBVPRIVLEGES" 56.82 KB 221 rows . . imported "CIRQIT"."PBVROLE" 34.98 KB 144 rows . . imported "CIRQIT"."PBV_ROLE_PRIV" 23.22 KB 890 rows . . imported "CIRQIT"."PERFECTING_TYPE" 6.718 KB 18 rows . . imported "CIRQIT"."PERFORATION" 10.95 KB 21 rows . . imported "CIRQIT"."PLATE_TYPE" 7.828 KB 4 rows . . imported "CIRQIT"."POCKET_SIZE" 7.085 KB 3 rows . . imported "CIRQIT"."PREPRESS_METHOD" 11.5 KB 19 rows . . imported "CIRQIT"."PRESS_SIZES" 10.54 KB 20 rows . . imported "CIRQIT"."PRESS_TYPE" 6.890 KB 2 rows . . imported "CIRQIT"."PRINT_METHOD" 9.335 KB 17 rows . . imported "CIRQIT"."PRODUCTION_LOCATION" 7.289 KB 2 rows . . imported "CIRQIT"."PRODUCT_ARTWORK_SOURCE_TYPE" 14.71 KB 404 rows . . imported "CIRQIT"."PRODUCT_ARTWORK_TYPE_MAP" 12.39 KB 273 rows . . imported "CIRQIT"."PRODUCT_BINDING_MAP" 17.16 KB 341 rows . . imported "CIRQIT"."PRODUCT_COATING_STYLE_MAP" 8.257 KB 99 rows . . imported "CIRQIT"."PRODUCT_COATING_TYPE_MAP" 12.62 KB 280 rows . . imported "CIRQIT"."PRODUCT_COVERAGE_MAP" 10.40 KB 147 rows . . imported "CIRQIT"."PRODUCT_DELIVERY_METHOD_MAP" 9.445 KB 152 rows . . imported "CIRQIT"."PRODUCT_DESKTOP_MINUTES_MAP" 6.578 KB 29 rows . . imported "CIRQIT"."PRODUCT_DIE_BUSINESS_CARD_MAP" 6.062 KB 8 rows . . imported "CIRQIT"."PRODUCT_DRILLING_MAP" 9.929 KB 132 rows . . imported "CIRQIT"."PRODUCT_FLAP_EDGE_MAP" 6 KB 6 rows . . imported "CIRQIT"."PRODUCT_FLAP_STYLE_MAP" 6.289 KB 18 rows . . imported "CIRQIT"."PRODUCT_GLUE_TAB_MAP" 6.007 KB 8 rows . . imported "CIRQIT"."PRODUCT_LABELING_OPTION_MAP" 9 KB 116 rows . . imported "CIRQIT"."PRODUCT_MAILING_OPTION" 8.609 KB 104 rows . . imported "CIRQIT"."PRODUCT_OPENING_FEATURES_MAP" 6.078 KB 12 rows . . imported "CIRQIT"."PRODUCT_PAPER_FINISH_MAP" 26.90 KB 829 rows . . imported "CIRQIT"."PRODUCT_PERFORATION_MAP" 8.273 KB 92 rows . . imported "CIRQIT"."PRODUCT_POCKET_SIZE_MAP" 5.906 KB 3 rows . . imported "CIRQIT"."PRODUCT_PREPRESS_METHOD_MAP" 17.64 KB 519 rows . . imported "CIRQIT"."PRODUCT_PRINT_METHOD_MAP" 10.73 KB 180 rows . . imported "CIRQIT"."PRODUCT_PRODUCTION_LOC_MAP" 7.156 KB 56 rows . . imported "CIRQIT"."PRODUCT_REGISTRATION_MAP" 8.593 KB 110 rows . . imported "CIRQIT"."PRODUCT_SCORE_MAP" 8.093 KB 102 rows . . imported "CIRQIT"."PRODUCT_SEALING_METHOD_MAP" 6.609 KB 32 rows . . imported "CIRQIT"."PRODUCT_SEAM_STYLE_MAP" 6.125 KB 12 rows . . imported "CIRQIT"."PRODUCT_TINTED_ENVELOPE_MAP" 5.929 KB 3 rows . . imported "CIRQIT"."PRODUCT_TYPE" 20.84 KB 82 rows . . imported "CIRQIT"."PRODUCT_TYPE_SPEC_TYPE_MAP" 6.945 KB 45 rows . . imported "CIRQIT"."PRODUCT_WINDOW_OPTION_MAP" 5.898 KB 2 rows . . imported "CIRQIT"."PRODUCT_WORKFLOW_TYPE_MAP" 6.218 KB 12 rows . . imported "CIRQIT"."QUALITY_RATING" 7.328 KB 3 rows . . imported "CIRQIT"."RECYCLED_PAPER" 7.773 KB 9 rows . . imported "CIRQIT"."REGION" 8.046 KB 14 rows . . imported "CIRQIT"."REGISTRATION" 7.312 KB 4 rows . . imported "CIRQIT"."SCORE" 7.187 KB 3 rows . . imported "CIRQIT"."SEALING_METHOD" 7.312 KB 6 rows . . imported "CIRQIT"."SEAM_STYLE" 7.140 KB 5 rows . . imported "CIRQIT"."SEPARATION_METHOD" 7.445 KB 7 rows . . imported "CIRQIT"."SIDE_LAYOUT" 7.820 KB 7 rows . . imported "CIRQIT"."SPEC_TYPE" 7.601 KB 9 rows . . imported "CIRQIT"."STATUS" 27.92 KB 114 rows . . imported "CIRQIT"."SUPPLIER_TYPE" 14.07 KB 50 rows . . imported "CIRQIT"."SUPPLIER_TYPE_PRODUCT_MAP" 10.02 KB 165 rows . . imported "CIRQIT"."TINTED_ENVELOPE" 7.078 KB 3 rows . . imported "CIRQIT"."USER_TYPE" 7.523 KB 5 rows . . imported "CIRQIT"."WINDOW_OPTION" 6.882 KB 2 rows . . imported "CIRQIT"."WORKFLOW_TYPE" 7.164 KB 3 rows . . imported "CIRQIT"."BACKER" 7.015 KB 4 rows . . imported "CIRQIT"."BANDING_TYPE" 8.5 KB 13 rows . . imported "CIRQIT"."BLS_PRODUCT_CODE" 10.10 KB 13 rows . . imported "CIRQIT"."CALCULATION_RULE_TYPE" 8.140 KB 19 rows . . imported "CIRQIT"."CALCULATION_TYPE" 6.453 KB 1 rows . . imported "CIRQIT"."CALC_LEVEL" 6.703 KB 2 rows . . imported "CIRQIT"."CALC_QTY_OPTION" 18.10 KB 101 rows . . imported "CIRQIT"."CALC_STEPPED_QTY_RANGE" 20.19 KB 441 rows . . imported "CIRQIT"."CARRIER" 7.976 KB 4 rows . . imported "CIRQIT"."COC_CERT" 7.687 KB 4 rows . . imported "CIRQIT"."COLUMNS_MASTER" 28.10 KB 132 rows . . imported "CIRQIT"."CONTACT_TYPE" 8.304 KB 7 rows . . imported "CIRQIT"."CORE_SIZE" 7.062 KB 4 rows . . imported "CIRQIT"."COUNTRY" 10.39 KB 37 rows . . imported "CIRQIT"."CURRENCY" 9.531 KB 23 rows . . imported "CIRQIT"."CURRENCY_EXCHANGE_PAIR" 6.367 KB 26 rows . . imported "CIRQIT"."DATA_TYPE" 6.765 KB 4 rows . . imported "CIRQIT"."DATE_RANGE_RULE" 8.671 KB 8 rows ORA-31693: Table data object "CIRQIT"."DEPENDENT_TASK_MAP" failed to load/unload and is being skipped due to error: ORA-02291: integrity constraint (CIRQIT.DEPENDENT_TASK_FK) violated - parent key not found . . imported "CIRQIT"."DESCRIPTOR" 40.21 KB 279 rows . . imported "CIRQIT"."DESTINATION_TYPE" 6.968 KB 2 rows . . imported "CIRQIT"."DIE_PRF_SCORE_METHOD" 7.171 KB 3 rows . . imported "CIRQIT"."EDI_SCHEDULE" 7.804 KB 5 rows . . imported "CIRQIT"."EMAIL_TYPES" 7.515 KB 6 rows . . imported "CIRQIT"."ENVELOPE_SEAM" 7.718 KB 5 rows . . imported "CIRQIT"."ENVELOPE_STYLE" 11.17 KB 11 rows . . imported "CIRQIT"."ESTIMATE_TYPE" 6.812 KB 4 rows . . imported "CIRQIT"."FAILED_LOGIN_TRIES" 7 KB 3 rows . . imported "CIRQIT"."FILE_DELETE_RULE" 7.476 KB 4 rows . . imported "CIRQIT"."FILE_FORMAT" 6.867 KB 3 rows . . imported "CIRQIT"."FILE_TYPE" 7.609 KB 8 rows . . imported "CIRQIT"."FORM_BLEED" 7.671 KB 4 rows . . imported "CIRQIT"."FORM_RUN_RULE" 7.765 KB 10 rows . . imported "CIRQIT"."FORM_TYPE" 8.781 KB 16 rows . . imported "CIRQIT"."INVOICE_EXPORT_TYPE" 6.898 KB 2 rows . . imported "CIRQIT"."INVOICE_TYPE" 7.164 KB 4 rows . . imported "CIRQIT"."JOB_STAGE" 7.726 KB 6 rows . . imported "CIRQIT"."LANGUAGE" 7.273 KB 7 rows . . imported "CIRQIT"."MATERIAL" 17.03 KB 64 rows . . imported "CIRQIT"."MATERIAL_ADJUSTMENT_TYPE" 6.468 KB 3 rows . . imported "CIRQIT"."MERCHANT" 7.335 KB 2 rows . . imported "CIRQIT"."MERCHANT_DIVISION" 9.414 KB 69 rows . . imported "CIRQIT"."MERCHANT_ITEM_TYPE" 6.531 KB 2 rows . . imported "CIRQIT"."MIME_TYPE" 13.28 KB 30 rows . . imported "CIRQIT"."NOTIFICATION_ACTION" 7.421 KB 3 rows . . imported "CIRQIT"."NUMBERING_POSITIONS" 7.101 KB 6 rows . . imported "CIRQIT"."NUMBERING_TYPE" 6.921 KB 3 rows . . imported "CIRQIT"."NUMBER_UP" 7.320 KB 6 rows . . imported "CIRQIT"."ORG_PREFERENCE" 23.23 KB 63 rows . . imported "CIRQIT"."OUTSIDE_CONTACT_TYPE" 6.812 KB 1 rows . . imported "CIRQIT"."OUTSIDE_DIAMETER" 7.062 KB 4 rows . . imported "CIRQIT"."PACKING" 7.414 KB 5 rows . . imported "CIRQIT"."PADDING" 7.25 KB 5 rows . . imported "CIRQIT"."PAPER_BASIS_SIZE" 7.148 KB 7 rows . . imported "CIRQIT"."PAPER_SHIPMENT_TYPE" 8.054 KB 7 rows . . imported "CIRQIT"."PARTS_TYPE" 7.445 KB 6 rows . . imported "CIRQIT"."PAYMENT_METHOD" 7.437 KB 3 rows . . imported "CIRQIT"."PLAN_TABLE" 20.06 KB 132 rows ORA-31693: Table data object "CIRQIT"."PPI_HISTORY" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-00001: unique constraint (CIRQIT.PPI_HISTORY_PL) violated . . imported "CIRQIT"."PROCESS_CALC" 6.484 KB 7 rows . . imported "CIRQIT"."PRODUCTION_ALTERNATIVE" 6.648 KB 7 rows . . imported "CIRQIT"."PRODUCT_BACKER_MAP" 6.453 KB 8 rows . . imported "CIRQIT"."PRODUCT_BANDING_TYPE_MAP" 12.82 KB 306 rows . . imported "CIRQIT"."PRODUCT_CORE_SIZE_MAP" 6.5 KB 8 rows . . imported "CIRQIT"."PRODUCT_ENVELOPE_SEAM_MAP" 6.265 KB 15 rows . . imported "CIRQIT"."PRODUCT_ENVELOPE_STYLE_MAP" 6.468 KB 21 rows . . imported "CIRQIT"."PRODUCT_FORM_BLEED_MAP" 6.484 KB 8 rows . . imported "CIRQIT"."PRODUCT_FORM_TYPE_MAP" 7.171 KB 30 rows . . imported "CIRQIT"."PRODUCT_NBR_POSITIONS_MAP" 6.609 KB 12 rows . . imported "CIRQIT"."PRODUCT_NUMBERING_TYPE_MAP" 6.421 KB 6 rows . . imported "CIRQIT"."PRODUCT_NUMBER_UP_MAP" 6.617 KB 12 rows . . imported "CIRQIT"."PRODUCT_OUTSIDE_DIAMETER_MAP" 6.515 KB 8 rows . . imported "CIRQIT"."PRODUCT_PACKING_MAP" 6.140 KB 10 rows . . imported "CIRQIT"."PRODUCT_PADDING_MAP" 6.523 KB 10 rows . . imported "CIRQIT"."PRODUCT_PAPER_GRADE_MAP" 12.26 KB 216 rows . . imported "CIRQIT"."PRODUCT_PARTS_TYPE_MAP" 6.601 KB 12 rows . . imported "CIRQIT"."PRODUCT_REPRINT_MAP" 8.703 KB 117 rows . . imported "CIRQIT"."PRODUCT_REWIND_MAP" 6.601 KB 12 rows . . imported "CIRQIT"."PRODUCT_STUB_POSITION_MAP" 6.523 KB 10 rows . . imported "CIRQIT"."PRODUCT_STUB_SIZE_MAP" 6.593 KB 12 rows . . imported "CIRQIT"."PRODUCT_TRANSFER_METHOD_MAP" 6.515 KB 8 rows . . imported "CIRQIT"."PRODUCT_WINDOW_DIE_MAP" 6.125 KB 11 rows . . imported "CIRQIT"."PRODUCT_WINDOW_PATCH_MAP" 6.085 KB 9 rows . . imported "CIRQIT"."PRODUCT_WINDOW_PLACEMENT_MAP" 6.023 KB 6 rows . . imported "CIRQIT"."PROJECT_KIT" 8.218 KB 47 rows . . imported "CIRQIT"."QTY_RANGE_TYPE" 6.359 KB 3 rows . . imported "CIRQIT"."RATING_CATEGORY" 13.03 KB 7 rows . . imported "CIRQIT"."RATING_VALUE" 6.375 KB 6 rows . . imported "CIRQIT"."REPORT_GROUP" 8.953 KB 17 rows . . imported "CIRQIT"."REPRINT" 7.476 KB 3 rows . . imported "CIRQIT"."REWIND" 8.445 KB 6 rows . . imported "CIRQIT"."SCP_RATIONALE" 10.92 KB 32 rows . . imported "CIRQIT"."SPECIFICATION_DESCRIPTOR_MAP" 27.52 KB 565 rows ORA-31693: Table data object "CIRQIT"."STATIC_DESCRIPTOR" failed to load/unload and is being skipped due to error: ORA-00001: unique constraint (CIRQIT.STATIC_DESCRIPTOR_PK) violated . . imported "CIRQIT"."STATIC_RATING_CATEGORY" 12.20 KB 6 rows . . imported "CIRQIT"."STUB_POSITION" 7.093 KB 5 rows . . imported "CIRQIT"."STUB_SIZE" 7.218 KB 6 rows . . imported "CIRQIT"."SUPPLEMENTAL_ITEM_TYPE" 7.890 KB 8 rows . . imported "CIRQIT"."SUPPLIER_BUSINESS_CLASS" 6.757 KB 3 rows . . imported "CIRQIT"."SUPPLIER_RANK_VISIBILITY" 7.718 KB 4 rows . . imported "CIRQIT"."SUPPLIER_TYPE_COST_CAT_MAP" 11.27 KB 278 rows . . imported "CIRQIT"."SUPP_ITEM_COST_CAT_MAP" 7.757 KB 32 rows . . imported "CIRQIT"."TEMPLATE_MASTER" 18.18 KB 229 rows . . imported "CIRQIT"."TIME_ZONE" 32.47 KB 557 rows . . imported "CIRQIT"."TRANSFER_METHOD" 7.359 KB 4 rows . . imported "CIRQIT"."UNIT_OF_MEASURE" 8.578 KB 15 rows . . imported "CIRQIT"."WINDOW_DIE" 7.851 KB 5 rows . . imported "CIRQIT"."WINDOW_PATCH" 6.906 KB 3 rows . . imported "CIRQIT"."WINDOW_PLACEMENT" 6.828 KB 2 rows . . imported "CIRQIT"."ADDL_INK" 0 KB 0 rows . . imported "CIRQIT"."BILLING_STATUS" 0 KB 0 rows . . imported "CIRQIT"."CLUSTER_SYNC" 0 KB 0 rows . . imported "CIRQIT"."FINISHED_SIDES" 0 KB 0 rows . . imported "CIRQIT"."PRODUCT_TYPE_PAPER_MAP" 0 KB 0 rows . . imported "CIRQIT"."PROGRAM_KIT_MAP" 0 KB 0 rows . . imported "CIRQIT"."SIDE" 0 KB 0 rows Job "SYSTEM"."SYS_IMPORT_TABLE_01" completed with 5 error(s) at 14:16:02