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
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