求救:exp导出整个库报错!

realsumboy

大家帮忙看一下,从8i导出整个数据库报错,谢谢!
OS:redhat as2.1       DB:8.1.7.4
脚本:exp  system/manager@higms
Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
Enter array fetch buffer size: 4096 >
Export file: expdat.dmp > sun-ming1105.dmp
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > E
Export grants (yes/no): yes >
Export table data (yes/no): yes >
Compress extents (yes/no): yes >
Export done in ZHS16CGB231280 character set and ZHS16CGB231280 NCHAR character s
et
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting foreign function library names
. exporting object type definitions
EXP-00008: ORACLE error 1406 encountered
ORA-01406: fetched column value was truncated
EXP-00000: Export terminated unsuccessfully
/higms/higmsdb/8.1.7/bin$

[ 本帖最后由 realsumboy 于 2008-11-6 15:43 编辑 ]

jylking

metalink.oracle.com

Subject:  Full Database Export Failed With EXP-00008 and ORA-01406 ORA-01406
  Doc ID:  Note:226277.1 Type:  PROBLEM
  Last Revision Date:  02-APR-2003 Status:  PUBLISHED


PROBLEM:
+++++++++

You are experiencing failure when doing full database export:
EXP-00008: ORACLE error 1406 encountered
ORA-01406: fetched column value was truncated
EXP-00000: Export terminated unsuccessfully

SOLUTION:
+++++++++

Bug1874468 is being encountered. The Bug is fixed in the 8.1.7.3 patch set but
one-off patches are also available for various platforms.

Since this is an Oracle Clinical database and Oracle Clinical is only
certified to 8.1.7.2, can this Patch be installed?

Oracle Clinical Development confirmed that you could apply the RDBMS patch.