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!

IMP-00064: Definition of LOB was truncated by export

700833Jul 29 2009 — edited Aug 3 2009

Hi,
I came across this warning in the import log file. Upon research I found there were 2 solutions, Oracle's knowledge base gives a very minimally detailed solution - 'Delete the offending row'. I don't know how to find the offending row.

And the 2nd one is to increase the size of the tablespace into which the table is being imported since the LOB columns take up a lot of space over time.

I don't want to delete any rows and jeopardize the application.
Any suggestions?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 31 2009

Added on Jul 29 2009

#general-database-discussions

2 comments

2,451 views