Import problem Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Import problem

  1. #1
    Join Date
    Sep 2003

    Import problem

    I have a import/export problem here. I exported a user(PROD1) using system user in Server A. When I import that user into Server B I got the following error. Have tried to increase the import buffer to 200,000 but still the same.

    . . importing table "TB_MACHINE1"
    IMP-00020: long column too large for column buffer size (22)
    IMP-00028: partial import of previous table rolled back: 45580 rows rolled back
    . . importing table "TB_MACHINE2"
    IMP-00009: abnormal end of export file
    Import terminated successfully with warnings.

    Then I export the user(PROD1) using prod1 user in Server A. When I import the user into Server B this time got no error? How come? I have tried many times. Why the error comes out when I use system to export the user? Any idea? Tks.

  2. #2
    Join Date
    Feb 2000
    Import buffer is not large enough, Increase the BUFFER parameter used for importing.

    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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