hpcrm1:/app/others/mig#imp TRANSDATA/TRANSDATA file=/app/others/mig/tanwenlin/transdata1.dump full=yImport: Release 10.1.0.2.0 - Production on Wed Feb 10 15:17:11 2010Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
export client uses AL32UTF8 character set (possible charset conversion)
. importing TRANSDATA's objects into TRANSDATAMemory fault(coredump)导入不成功。不知道错误原因。
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
export client uses AL32UTF8 character set (possible charset conversion)
. importing TRANSDATA's objects into TRANSDATAMemory fault(coredump)导入不成功。不知道错误原因。
按照提示操作下
看看什么结果?
*
第 1 行出现错误:
ORA-14404: 分区表包含不同表空间中的分区
这是一个什么问题。文件不存在了。
// *Cause: An attempt was made to drop a tablespace which contains tables
// whose partitions are not completely contained in this tablespace
// *Action: find tables with partitions which span the tablespace being
// dropped and some other tablespace(s). Drop these tables or move
// partitions to a different tablespace
错误提示,还是原版的好。一目了然。你要删掉的表空间包含某分区表,但该分区表的所有分区并不是仅在该表空间。