-
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
-
$ 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.
-
could you please tell me how much size i can give for buffer.
This table is having 158 rows.
Thanks
Ravi
ravi
-
Try to perform the import without specifying buffer size.
-
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
-
This question makes me think what will happen
if a 10+M sized table (like cravi's) and my exp filesize
setting is 5M?
-
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
-
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
-
Hmm. Check on Metalink for related docs on such imports.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|