Roads ? - where we're going, we don't need roads ...
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
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
Europe
Belgium :
Kurt Van Meerbeeck
ORA600 bvba
E-mail
dude@ora600.be
Cell : +32 495 580714
Denmark :
Henrik Bjerknæs Rasmussen
Service & Support Manager
Miracle AS
E-mail :
hra@miracleas.dk
Cell: +45 53 747 110
North America
USA :
Tim Gorman
Evdbt Inc
E-mail
tim@evdbt.com
Cell : +1 303 885 4526
Canada :
Pythian
E-mail
dude@pythian.com
Contact
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
East Asia Pacific
Australia
Andre Araujo
Pythian Australia
E-mail
dude@pythian.com
Cell : +61 2 9191 7427 ext. 1270
Content RSS