Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMPORT ERROR

416986Mar 16 2004 — edited Mar 24 2004
Hi All,

I have Oracle 8i Enterprise Edition

am trying to import dmp file. While doing an import I am getting the following errors and the import is partial.
----------------------
. . importing table "PICI"
IMP-00020: long column too large for column buffer size (8)
IMP-00018: partial import of previous table completed: 735828 rows imported
----------------------

All other tables where imported successfully.

The command i used is:

imp udthe/udthe@goldrake fromuser=tributi touser=udthe file=trib.dmp log=udthe.log commit=y ignore=y tables=pici buffer=1024000
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2004
Added on Mar 16 2004
2 comments
123 views