Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    10

    Unanswered: abnormal end of export file(export/import)

    while i was importing my oracle backup file(dmp file)
    following error message came and importing terminated.
    'IMP-00009: abnormal end of export file'.
    we tried the same(importing) in some other machines too,
    but the result was the same.

    we are using oracle replication.
    our backup file(dmp file) size is around 500 mb.

    Before showing the above error message some other error
    messages also came like the following:

    'IMP-00020: long column too large for column buffer size (1)
    'IMP-00017: following statement failed with ORACLE error 942:'
    "COMMENT ON TABLE "MLOG$_BILLBROK_MST" IS 'snapshot log for master table ST"
    "OCKSERGE.BILLBROK_MST'"
    'IMP-00003: ORACLE error 942 encountered'
    'ORA-00942: table or view does not exist'

    i am also attaching the log file created while importing.
    it would help you to get more information about the problem.

    expecting your help at the earliest.
    thank you.
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Increase the size of the buffer. make it 10k or more temporarily.
    If it fails with the same error, then again increase the size more.
    Following these procedure should solve your problem
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Dec 2003
    Posts
    10

    Re: abnormal end of export file(export/import)

    I tried to import the same by giving
    buffer size starting from 10k to 100m,
    but the result was the same.

    i need more help from you.

Posting Permissions

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