/data/oracle/product/10.2.0.1/bin/exp  userid=hmp/passwd@sid  log=/backup/exp_log.hmp.`date +%F`.txt  file=/backup/export_hmp_`date '+%Y-%m-%d'`.dmp

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user HMP
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user HMP
About to export HMP's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00000: Export terminated unsuccessfully

解决：

SQL> conn /as sysdba;
Connected.
SQL> @?/rdbms/admin/catmetx.sql