Oracle数据库|exp导出问题


昨天payment从测试库到另外一个测试库进行迁移,导出时,出现如下故障:

  [oracle@oracle02 ~]$ exp userid=test/test file=test.dmp buffer=1024 owner=test

  Export: Release 10.2.0.1.0 - Production on Tue Nov 28 15:09:42 2006

  Copyright (c) 1982, 2005, Oracle. All rights reserved.

  Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

  With the Partitioning, Real Application Clusters, OLAP and Data Mining options

  Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

  About to export specified users ...

  .EXP-00056: ORACLE error 932 encountered

  ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR

  EXP-00000: Export terminated unsuccessfully

  原因:数据字典中有存在一些无效KU Oracle数据库|exp导出问题 - 站长学院

Oracle数据库|exp导出问题

2008-5-2 19:55:00查看学习心得
{GetProperty(Content)} 本文作者:
« 
» 

Copyright © 2016 phpStudy | 豫ICP备2021030365号-3