Andrew, if you are doing the export and import on the same instance you
might want to check if you have objects in the wrong tablespaces.
I think the query is
select OWNER,
SEGMENT_NAME,
SEGMENT_TYPE,
TABLESPACE_NAME,
BYTES
from dba_segments
order by OWNER, SEGMENT_NAME
You can end up with clobs from the prod tablespace in the dev tablespace and vice versa depending on the permissions for the
importing users.
