Skip to Main Content
Forums

Database Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

IMP-00051 Direct path exported dump file contains illegal column length

Santosh PradhanAug 3 2017 — edited Aug 3 2017

EXP done on 11.2.0.2 :-

Doing IMP on 11.2.0.4:-

Getting below errors while trying to imp .

IMP-00051: Direct path exported dump file contains illegal column length

IMP-00018: partial import of previous table completed: %lu rows imported

IMP-00008: unrecognized statement in the export file: n %s

IMP-00009: abnormal end of export file

Comments

MateuszH

hi,

Traditional Import (IMP) Raises Error IMP-51 Direct Path Exported Dump File Contains Illegal Column Length (Doc ID 1403865.1)

Instead of using the traditional export/import, use the DataPump export/import as a workaround.

So just use impdp/expdp instead of imp/exp

m.

Dean Gagne-Oracle

There is a little more than just using 'expdp/impdp', but I agree, you should be using Data Pump instead of the original exp/imp tools.  Data Pump has been around since 10.1 and has a lot more features and potentially bug fixes than exp/imp may have.  Since your source and target are both later than 10.1, Data Pump is the way to go.  You should be able to use most of your parameters, Data Pump will convert them for you.  What you will need to do is create a directory and directory object for Data Pump to use.

Dean

1 person found this helpful
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 31 2017
Added on Aug 3 2017
#database-key-features, #export-import-sql-loader-external-tables
2 comments
1,101 views