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

Thread: Import problem

  1. #1
    Join Date
    Sep 2003
    Location
    China
    Posts
    72

    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
    Location
    Singapore
    Posts
    1,758
    Import buffer is not large enough, Increase the BUFFER parameter used for importing.

    HTH
    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