DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: IMP-00009: abnormal end of export file

Threaded View

  1. #1
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322

    IMP-00009: abnormal end of export file

    I exported a database schema using direct path export (the export log is attached) from Solaris 8 machine and tried to import it on a Windows Server 2003 machine. The Oracle version on both machines is 10.1.0.3. An error occurs 'IMP-00009: abnormal end of export file' when 93 tables are imported and 5 are left. Used the metalink but could not find anything, the pages I found show the failure of import utility right at the start and not after importing some tables. The description of the table at which import fails is:


    SQL> desc mam_mmo_data
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    MMO_ID NOT NULL NUMBER(10)
    MMO_INDEX NOT NULL NUMBER(6)
    BDATA BLOB
    BDATAFILE BINARY FILE LOB


    I used the following command to import schema:

    imp system/manager fromuser=quarkdms touser=quarkdms file=E:\dumps\quarkdms.dmp log=E:\dumps\lg.log


    The logs are:
    Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
    With the Partitioning, OLAP and Data Mining options

    Export file created by EXPORT:V10.01.00 via direct path
    import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
    . importing QUARKDMS's objects into QUARKDMS
    . . importing table "CBO_CND_ANALYZE_CTRL" 210 rows imported
    . . importing table "CBO_CND_ANALYZE_INFO" 6467 rows imported
    . . importing table "CBO_CTX_ANALYZE_CTRL" 5 rows imported
    . . importing table "CBO_CTX_OPTIMIZE_INFO" 3318 rows imported
    . . importing table "CBO_IND_REBUILD_INFO" 0 rows imported
    . . importing table "JN_ACTIONS" 0 rows imported
    . . importing table "JN_ACTION_DEFINITIONS" 0 rows imported
    . . importing table "JN_ASSETS" 61498 rows imported
    . . importing table "JN_ASSET_ATTR_STRING_BKP" 0 rows imported
    . . importing table "JN_ASSET_FOLDER_ASSIGNMENTS" 0 rows imported
    . . importing table "JN_ASSET_GROUPS" 0 rows imported
    . . importing table "JN_ASSET_KEYWORD_ASSIGNMENTS" 1506 rows imported
    . . importing table "JN_ASSET_RELS" 0 rows imported
    . . importing table "JN_ATTR_DATE_VALUES" 2735 rows imported
    . . importing table "JN_ATTR_DOMAIN_VALUES" 11192 rows imported
    . . importing table "JN_ATTR_NUMERIC_VALUES" 1709 rows imported
    . . importing table "JN_ATTR_STRING_VALUES" 10633 rows imported
    . . importing table "JN_ATTR_TEXT_VALUES" 620 rows imported
    . . importing table "JN_FOLDERS" 0 rows imported
    . . importing table "JN_KEYWORDS" 0 rows imported
    . . importing table "JN_KEYWORD_RELATIONS" 0 rows imported
    . . importing table "JN_QUERIES" 13 rows imported
    . . importing table "JN_RELATION_TYPES" 0 rows imported
    . . importing table "JN_SCHEDULES" 0 rows imported
    . . importing table "JN_TRUSTEES" 4 rows imported
    . . importing table "JN_USERCLASS_PRIVILEGE_VALUES" 0 rows imported
    . . importing table "JN_USERS" 0 rows imported
    . . importing table "JN_USER_CLASSES" 0 rows imported
    . . importing table "JN_USER_PREFERENCE_VALUES" 15 rows imported
    . . importing table "JN_VARCHARS" 0 rows imported
    . . importing table "JN_XTENSION_PREFERENCE_VALUES" 0 rows imported
    . . importing table "MAM_ACCESS_CONTROL_ELEMENTS" 1112 rows imported
    . . importing table "MAM_ACCESS_CONTROL_LISTS" 423 rows imported
    . . importing table "MAM_ACTIONS" 537 rows imported
    . . importing table "MAM_ACTION_DEFINITIONS" 39 rows imported
    . . importing table "MAM_ACTION_EXECUTIONS" 0 rows imported
    . . importing table "MAM_ACTION_LANGUAGES" 234 rows imported
    . . importing table "MAM_ACTION_LOG_ENTRIES" 602885 rows imported
    . . importing table "MAM_ACTUAL_PARAM_VALUES" 4658 rows imported
    . . importing table "MAM_ASSETS" 1665256 rows imported
    . . importing table "MAM_ASSET_FOLDER_ASSIGNMENTS" 3440 rows imported
    . . importing table "MAM_ASSET_GROUPS" 128 rows imported
    . . importing table "MAM_ASSET_GROUP_ICONS" 86 rows imported
    . . importing table "MAM_ASSET_GROUP_ICON_ASG" 125 rows imported
    . . importing table "MAM_ASSET_GROUP_LANGUAGES" 758 rows imported
    . . importing table "MAM_ASSET_INDEX_QUEUE" 0 rows imported
    . . importing table "MAM_ASSET_KEYWORD_ASSIGNMENTS" 1009570 rows imported
    . . importing table "MAM_ASSET_RELS" 980313 rows imported
    . . importing table "MAM_ATTRIBUTE_DEFINITIONS" 425 rows imported
    . . importing table "MAM_ATTRIBUTE_LANGUAGES" 2231 rows imported
    . . importing table "MAM_ATTRIBUTE_PRIVILEGES" 1470 rows imported
    . . importing table "MAM_ATTRIBUTE_RULES" 0 rows imported
    . . importing table "MAM_ATTR_DATE_VALUES" 3625715 rows imported
    . . importing table "MAM_ATTR_DOMAIN_VALUES" 41194450 rows imported
    . . importing table "MAM_ATTR_NUMERIC_VALUES" 6164295 rows imported
    . . importing table "MAM_ATTR_STRING_VALUES" 12085355 rows imported
    . . importing table "MAM_ATTR_TEXT_VALUES" 419644 rows imported
    . . importing table "MAM_CATEGORIES" 2 rows imported
    . . importing table "MAM_CATEGORY_LANGUAGES" 12 rows imported
    . . importing table "MAM_CLIENT_NAMES" 1 rows imported
    . . importing table "MAM_CLIENT_POOL" 1 rows imported
    . . importing table "MAM_CLUSTERS" 6 rows imported
    . . importing table "MAM_CLUSTER_ASSIGNMENTS" 12 rows imported
    . . importing table "MAM_DEF_SCALAR_VALUES" 51 rows imported
    . . importing table "MAM_DEPENDANTS" 201 rows imported
    . . importing table "MAM_DESTINATIONS" 6 rows imported
    . . importing table "MAM_DESTINATION_TRIGGER" 0 rows imported
    . . importing table "MAM_DOMAINS" 86 rows imported
    . . importing table "MAM_DOMAIN_LANGUAGES" 458 rows imported
    . . importing table "MAM_DOMAIN_VALUES" 1029 rows imported
    . . importing table "MAM_DOMAIN_VALUE_HIERARCHIES" 30 rows imported
    . . importing table "MAM_DOMAIN_VAL_LANGUAGES" 4489 rows imported
    . . importing table "MAM_EXTERNAL_DELETE_CANDIDATES" 0 rows imported
    . . importing table "MAM_FILE_ATTRIBUTES" 401 rows imported
    . . importing table "MAM_FILTER_ASSIGNMENTS" 100 rows imported
    . . importing table "MAM_FOLDERS" 304 rows imported
    . . importing table "MAM_GROUPS" 5 rows imported
    . . importing table "MAM_GROUP_MEMBERS" 55 rows imported
    . . importing table "MAM_GROUP_RELATIONS" 177 rows imported
    . . importing table "MAM_HEADER_VIEWS" 18 rows imported
    . . importing table "MAM_HEADER_VIEW_ITEMS" 749 rows imported
    . . importing table "MAM_HEADER_VIEW_LANGUAGES" 46 rows imported
    . . importing table "MAM_HEADER_VIEW_TRUSTEE_ASG" 18 rows imported
    . . importing table "MAM_HOSTS" 4 rows imported
    . . importing table "MAM_KEYWORDS" 1110 rows imported
    . . importing table "MAM_KEYWORD_LANGUAGES" 1144 rows imported
    . . importing table "MAM_KEYWORD_RELATIONS" 1110 rows imported
    . . importing table "MAM_LANGUAGES" 44 rows imported
    . . importing table "MAM_LOCATIONS" 1 rows imported
    . . importing table "MAM_LOG_ENTRIES" 3 rows imported
    . . importing table "MAM_LOG_LANGUAGES" 4374 rows imported
    . . importing table "MAM_LOG_MESSAGES" 729 rows imported
    . . importing table "MAM_MMO_DATA"
    IMP-00009: abnormal end of export file
    IMP-00027: failed to rollback partial import of previous table
    IMP-00003: ORACLE error 24909 encountered
    ORA-24909: call in progress. Current operation cancelled
    IMP-00000: Import terminated unsuccessfully
    Attached Files Attached Files
    lucky

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width