Quote Originally Posted by vnktummala View Post
yes, you have multiple ways to do that.

but, first place I am wordaring why imp is trying to insert null values. Because I am sure the NOT NULL constraint is there on the source table so no chance of having null values in source. Does it mean that the BLOB column data is not exported??

as the other poster said, drop that table with cascade constraints and let imp create the table and see how it goes.

Thanks,
I am arranging some more disk space as I am running out of it. Though I dropped the entire schema and tried import again.
I will try to do it the way as I suggested in my previous post and then let you know.