DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Import

  1. #1
    Join Date
    Nov 2000
    Posts
    157
    Hi Guys

    I exported the full database(Oracle 734 & Windows NT4.0) and imported it(Oracle734 & Windows Nt4.0).I Imported all the data successfully EXCEPT for one table.The Error message is:


    ..importing table "ATTACHMENT_BLOB"
    IMP-00020: long column too large for column buffer size (9999886)
    IMP-00028: partial import of previous table rolled back: 59 rows rolled back.

    I used the command:

    imp73 system/***** file='d:\export\exp.dmp log='d:\export\exp.log' buffer=10000000 full=y.

    Please let me know SOME SOLUTION TO IMPORT THIS TABLE ASAP.

    Thanks
    Ravi
    ravi

  2. #2
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    $ oerr imp 20
    00020, 00000, "long column too large for column buffer size (%lu)"
    // *Cause: The column buffer is too small for long column.
    // *Action: Increase the buffer size until it is big enough for the long columns being imported.

  3. #3
    Join Date
    Nov 2000
    Posts
    157
    could you please tell me how much size i can give for buffer.

    This table is having 158 rows.

    Thanks
    Ravi
    ravi

  4. #4
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    Try to perform the import without specifying buffer size.

  5. #5
    Join Date
    Nov 2000
    Posts
    157
    Hi

    If we didn't specify Buffer size it will take a default value of 4k which is not at all sufficient for LONG rows.

    what do you say?

    Thanks
    Ravi
    ravi

  6. #6
    Join Date
    Jun 2000
    Posts
    295
    This question makes me think what will happen
    if a 10+M sized table (like cravi's) and my exp filesize
    setting is 5M?

  7. #7
    Join Date
    Nov 2000
    Posts
    157
    Hi Halo

    Even i tried to import this table without specifying buffer size.The error message is:

    IMP-00020: long column too large for column buffer size (30606)

    Thanks
    Ravi
    ravi

  8. #8
    Join Date
    Nov 2000
    Posts
    157
    I am getting this error when i am tryiong to Import a Table:

    SQL> desc attachments_blob
    Name Null? Type
    ------------------------------- -------- ----
    ATTACHMENTS_DBID NUMBER(10)
    ENTITY_DBID NUMBER(10)
    ENTITY_FIELDDEF_ID NUMBER(10)
    DATA LONG RAW

    thanks
    ravi
    ravi

  9. #9
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    Hmm. Check on Metalink for related docs on such imports.

  10. #10
    Join Date
    Nov 2000
    Posts
    157
    hi Halo

    Please let me know the site to look into that

    Thanks Alot
    Ravi
    ravi

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