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

Thread: IMP-00009: abnormal end of export file

Hybrid 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

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    IMP-00009: abnormal end of export file

    Check your export log for any errors, looks like the export dump is not good...
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    Quote Originally Posted by Thomasps View Post
    IMP-00009: abnormal end of export file

    Check your export log for any errors, looks like the export dump is not good...
    Thanks Thomas! The export log was attached already, there are no errors.
    lucky

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Would you consider a couple of tests so to be sure dump file is not corrumpt?

    1- Try to import offending MAM_MMO_DATA table alone.
    2- Try to import table next to MAM_MMO_DATA, alone.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Mar 2011
    Posts
    2
    Hi ,

    Export file looks clean.

    Did you FTP your export file on some other server and then imported ..?

    If yes please transfer the file once again from the current location in proper binary mode..and then start the import once again

    Regards
    Amol Shinde

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