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
lucky
IMP-00009: abnormal end of export file
Check your export log for any errors, looks like the export dump is not good...
Originally Posted by
Thomasps
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
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.
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
Forum Rules
Click Here to Expand Forum to Full Width