Roads ? - where we're going, we don't need roads ...
IMP-00020: long column too large for column buffer size (22) during import using imp | ORA600
ORA600 content Content RSS
Oracle ORA600 News RRSS Oracle News RSS
ORA600 blog Blog RSS
ORA600 blog Blog Atom

User login

IMP-00020: long column too large for column buffer size (22) during import using imp

When you encounter the following error while import using imp :

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

IMP-00028: partial import of previous table rolled back: 36972 rows rolled back

Import terminated successfully with warnings.

 

Check the dude.log for this table - check if there were 'Fractured block' warnings while dump the table.

If so, the block is corrupted - either :

- dump to flatfile - load using sqlldr. sqlldr will skip the corrupted rows and load the rest of the data

- set SKIP_FRACTURED_BLOCK="true" - and redump to dmp. This will skip the complete block, losing more data, but resulting in a correct DMP file

 

 

 

latest

thanks due to the fact that this significant informative website, finance up the massive undertaking check out this online casino offers



Howto's
See DUDE primer for info

Get Support

Europe

Belgium :
Kurt Van Meerbeeck
ORA600 bvba
E-mail
dude@ora600.be
Cell : +32 495 580714

Denmark :
Michael Môller
Service & Support Manager
Miracle AS
E-mail :
hra@miracleas.dk
Cell: +45 53 74 71 27


Latin America

Brazil :
HBtec
E-mail
dude@hbtec.com.br
Cell : +55 47 88497639
Contact


Africa

South Africa :
Kugendran Naidoo
NRG Consulting
E-mail
k@nrgc.co.za
Cell : +27 82 7799275